Job History
The Job History report provides a visual and detailed view of SQL Server Agent job executions over a 24-hour timeline. This report helps you quickly understand when jobs ran, their outcomes, and how often they occurred throughout the day. It combines a timeline chart with a detailed list view for both high-level monitoring and in-depth troubleshooting.
24-Hour Timeline View
- Displays job executions across a full day.
- Each job run is shown in its scheduled time slot, making it easy to see patterns and overlap.
- Hovering over a job run shows the job name, start time, end time, and outcome.
- Filter options allow you to show only the jobs you are interested in, reducing clutter and focusing on what matters.
Detailed List View
The list below the timeline includes detailed execution data for each job step:
- Job Step – The specific step within a SQL Server Agent job.
- Start – The timestamp when the job step began.
- Duration – The total time the job step took to complete.
- Outcome – The result of the job step (succeeded, failed, retried, or canceled).
How to Use the Report
- Monitor Job Executions – Confirm that all scheduled jobs are running as expected throughout the day.
- Identify Job Failures – Use both the chart and list view to quickly spot jobs that failed and see exactly when it happened.
- Analyze Job Performance – Look for long-running jobs or overlapping jobs that may require tuning.
- Troubleshoot Issues – Drill down into the history of a specific job step to diagnose failures and performance problems.
Need Assistance?
If you need help troubleshooting failed jobs, optimizing SQL Server Agent performance, or automating database maintenance, Stedman Solutions can assist. Our SQL Server Managed Services provide expert support for SQL Agent job monitoring, troubleshooting, and automation best practices.
For expert guidance, contact us at Stedman Solutions.