SQL Server Agent
From Wikipedia, the free encyclopedia
SQL Server Agent is a component of Microsoft SQL Server which schedules jobs and handles other automated tasks.[1] It runs as a Windows service so it can start automatically when the system boots or it can be started manually.
![]() | This article includes a list of references, related reading, or external links, but its sources remain unclear because it lacks inline citations. (March 2025) |
Typical system tasks performed include scheduling maintenance plans (such as backups), handling Reporting Services subscriptions and performing log shipping sub-tasks (backup, copy, restore & check). User tasks, such as scheduling some T-SQL or command line statement are also common.
SQLAgent has support for operators and alerts, so that administrators can be notified, e.g. by email.
References
Wikiwand - on
Seamless Wikipedia browsing. On steroids.