SQL Server Management Studio Standard Reports – Top Jobs

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