SQL Agent Jobs
This page reads the state and history of SQL Server Agent jobs from msdb.dbo.sysjobs and
sysjobhistory – the scheduled tasks like backups, index maintenance or ETL.
What is shown
- Job status – enabled/disabled, last outcome (success/failure).
- Recent runs – result, duration and time of the most recent executions per job.
This surfaces failed or overdue jobs before they become a problem – for example a backup that has been silently failing for days.
Cloud note
msdb isn't available in the usual form on Azure SQL Database and AWS RDS; this area is skipped there automatically (see Getting started).
Combine overdue/failed jobs with alerts to be notified actively instead of checking manually.