I have made a generic report in Reporting Services 2008 to browse and display the job history of SQL Server Agent. This is very useful if you want to see what jobs fail the most, when do jobs overlap, is execution time increasing for a specific job etc. If you have many jobs, it can be quite useful to set up a subscription on this report, so you can see every day the status of alle the SQL Server Agent jobs. I use this report on all SQL Server Instances i control. I also recommend increasing the number of log entries stored in the log table on msdb to increase the usefulness of the report.  The report is made in Reporting Services 2008, but the query against log data works against 2005 and up.

The user account accessing the SQL Server database needs read-acces to msdb, and the report has two parameters:

• Search – For entering search strings. Useful if your project for example as prefixed job names with the project name
• Include Subscriptions – This parameter is useful if SQL Server has many reporting services subscriptions running. SSRS Subscriptions has a GUID as the name of the SQL Server Agent job, so they are quite easy to filter out.

Download here: http://www.sqldisco.com/files/Jobstatus.zip

Let me know if you find it useful, or if you have any recommended improvements I can implement.