Inspired by the SQLjobvis application, which works great btw.
But I wanted to make it a little neater and (of course) have the ability to schedule it daily 😉
Thus….here’s the result:
It displays the SQL Agent Job History of the past 24-hours, but you might want to increase that or even use Dynamic-SQL with Linked-Servers to have the option to select different SQL Servers.
In the query I’ve used the new TRY_CONVERT function of SQL Server 2012 (more info here). In case you want to use this report on 2005 or 2008 (R2), look for the function in the query and remove that part (prefix string for report subscriptions).
You may want to use the attached stored procedure or stick with the report which has the query built-in.
Also in the ZIP-file you find a SQL query that is compatible with SQL Server 2000 (but is of course a bit slower).
If you like the report, show your appreciation by sharing it on your blog or social media.
Have fun with it!
Download it here
Here’s another report of mine which you might find interesting:
SSRS: SQL Agent Job Status report