Default SQL Agent Reports – Top Jobs


July 24, 2017 by Kenneth Fisher

Looking at what a job has been doing is important. Particularly if something is going wrong. Now there are several ways to do this depending on your preference. You can use the system views.

Honestly, though, as much as I love writing queries for things these views are more than a bit difficult to work with.

So let’s look at the GUI. If you need to look at the error for a job or it’s output, in detail, the best way is to use the View History option.

But sometimes what you want is an overall history. Maybe you want to see your longest running jobs? Or the most frequent jobs? Or jobs that are failing? There is a great pre-built report just for that.

Now, be warned. The report and the history view both pull from the system views and they only hold so much history. You need to make sure that you are aware of what your job history system settings are.

And of course, all of this is to view the job information across a single server. If you want to view aggregate data across multiple instances you’ll have to either roll your own solution using SSIS, Powershell, etc, or use a paid product like Idera’s SQL Server Job Manager, Redgate’s SQL Monitor or Minion Enterprise.

3 thoughts on “Default SQL Agent Reports – Top Jobs

  1. […] Kenneth Fisher only looks at the best SQL Agent jobs: […]

  2. satish says:

    can we able to get the query out of this reports of “Default SQL Agent Reports – Top Jobs”

    • I’m not sure if there is an easy way to get it but you could try running an EE session and then running the report and see if it pulls anything. Otherwise you can go looking at the msdb.dbo.sysjobhistory.

Leave a Reply

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

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

Facebook photo

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

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 3,755 other subscribers

Follow me on Twitter

ToadWorld Pro of the Month November 2013
%d bloggers like this: