Alert based reporting

Hello, I am very new to the capabilities of the profiler server. I am curious what the best route to take to make a report only run if some event happens. For an example, I would like for a report about a back up failure at the end of the week, meaning, the report will only be sent via email if there is an error or failure in the back up. The email would then have specifics about the server that failed and the files that could not be backed up.

Do I have to write a custom script for this sort of job? Any help or direction is greatly appreciated!