Details

This screen displays job execution details for a single Instance. View the details for a previously selected Instance, or when prompted, select a specific Instance from the Instance drop-down list. The selected Instance name will be displayed.

Similar to the Jobs - Overview screen, the page contains three cards: a chart displaying the times and counts of jobs running, high-level analytics information, and activity details.

The Time Series / Daily Snapshot / Hourly Snapshot chart and the Jobs Analytics card are identical to the same cards on the overview screen, just filtered to a single instance. The Top Events card shows details for each job.

Use the drop-down menus to further filter the list by Instance, Category, Name, and/or Tag.

Top Events

This card displays detailed information for each job for a single Instance in a table format with sortable columns, as follows:

The Name column displays the Job Name.
The Category column displays the category name.
The Enabled column displays "Yes" for jobs that are enabled, and "No" for disabled jobs.
The Successful Executions column displays the count of successful executions during the selected time range.
The Failed Executions column displays the count of failed executions during the selected time range.
The Last Failure column displays the date and time for the last failure of that job during the selected time range.
The Average Duration column displays the average runtime of that job during the selected time range.
The Max Duration displays the maximum runtime of that job during the selected time range.

Note: Click on column headings to sort the list in ascending or descending order.

This data on Blocking can be further examined by using the Group By drop-down menu, as follows:

By Category: Displays a sortable list by Category, Successful Executions, Failed Executions, Last Failure, Average Duration, and Max Duration.
- Click the arrow [>] to the left of the row to see details for a specific Category by Name, Enabled, Successful Executions, Failed Executions, Last Failure, Average Duration, and Max Duration.
By Enabled: Displays a filtered list of only enabled jobs by Enabled, Name, Successful Executions, Failed Executions, Last Failure, Average Duration, and Max Duration.

Click on a row to display the Job Details flyout for more detailed job data.

Job Details Flyout

This flyout displays more details for the selected job and is made up of four cards:

The Properties card displays the Beginning and ending Date range selected on the prior screen, Instance, Name, Created Date, Enabled, Category, and Modified Date.

The Job Description card displays the full description field as set for the job in SQL Server Agent.

The Job Analytics card displays data for the selected time period along with change vs the prior time period for Success Rate, Average Duration, and Max duration. The Last Failure date and time for the selected period, if any, is also displayed.

The Job Schedule Card displays the schedule information for that job if it is running on a schedule.