SQL Server Management Studio Standard Reports – Top Jobs

SQL Server Management Studio Standard Reports – Top Jobs

  • Comments 1
I'm continuing my series on the Standard Reports in SQL Server Management Studio, and today we’re in the management reports. You can find these reports by starting SQL Server Management Studio and right-clicking the SQL Server Agent node. From the menu that appears, click the Standard Reports, and then select the title at the top of this post. This report shows Instance information about the top jobs your SQL Server Agent runs. This is another report you should check every day.

The first section of the report shows you a graph showing the number of successful and failed job runs.

Each of the bands in the report have the same columns, but show different information:

  • 20 Most Frequently Executed Jobs
  • 20 Most Frequently Failing Jobs
  • 20 Slowest Jobs

The information shown in each report is:

Column Description
Job Name The recorded name of the job
Owner Name The principal that owns the job
# Total Executions The number of times the job has run, successfully or not
# Failed Executions The number of times the job has failed
Avg. Run Duration (sec.) The average time, in seconds, that the job takes
# Avg. Retries The average number of times the job had to restart
# Steps The number of steps in the job
# Schedules The number of schedules that apply to this job

Leave a Comment
  • Please add 3 and 4 and type the answer here:
  • Post