SQL Server Agent is a Windows service that executes scheduled administrative tasks — called jobs — in SQL Server.
- DBAs use SQL Server Agent to automate maintenance tasks such as: Index rebuilds, database backups, integrity checks, and statistics updates.
- Jobs are composed of one or more steps: They can be scheduled by time, SQL Server event, or CPU idle conditions.
- Alerts can be configured to notify DBAs: Via email or pager when specific SQL Server errors or performance thresholds are triggered.
- SQL Server Agent uses a job history log: It tracks execution success, failure, and duration for auditing and troubleshooting.
- In high-availability environments: SQL Server Agent jobs must be configured separately on each replica — a common DBA oversight.
- Related Idera tools: SQL Diagnostic Manager monitors SQL Server Agent job health and alerts on failed or long-running jobs.
- Related terms: SQL Server Agent Job, Maintenance Plans, MSDB database.
