SSRS: SQL Agent Job Schedule Timeline report

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:

sql-agent-job-schedule-timeline-report

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.

Important note:
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:
Download it here


Here’s another report of mine which you might find interesting:
SSRS: SQL Agent Job Status report

sql-agent-jobs-report








Advertisements

3 thoughts on “SSRS: SQL Agent Job Schedule Timeline report

  1. Pingback: SSRS: SQL Agent Job Status report | Clint Huijbers' Blog

  2. Pingback: SSRS – Report Execution Analysis | Clint Huijbers' Blog

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s