A Windows service included with SQL Server that automates administrative tasks by executing scheduled jobs, responding to events, and sending notifications.
- Job execution: SQL Server Agent runs jobs composed of one or more steps. Each step can execute Transact-SQL (T-SQL), SSIS packages, PowerShell scripts, command-line programs, or replication agent tasks.
- Job triggers: Jobs can be triggered by schedules (time-based), SQL Server Alerts (based on error numbers or performance conditions), or WMI events, enabling both proactive and reactive automation.
- Common use cases: DBAs use SQL Server Agent to automate routine maintenance tasks such as backups, index rebuilds, statistics updates, database integrity checks, and ETL processes.
- Operators and notifications: SQL Server Agent operators define notification targets, such as email addresses or pager numbers, that receive alerts when jobs fail or performance thresholds are exceeded.
- Service dependency: SQL Server Agent must be running for replication agents, log shipping jobs, Database Mail, and maintenance plans to function properly. Monitoring the Agent service is essential for reliable operations.
- Relevant Idera tools: SQL Diagnostic Manager monitors SQL Server Agent job success, failure rates, and execution duration, providing real-time alerts for failed jobs.
- Related terms: Agents, Maintenance Plans, Backup, Replication, SQL Server Profiler.
