SQL Server Agent
SQL Server Agent runs on the server running instances of Microsoft® SQL Server™ 2000 or earlier versions of SQL Server. SQL Server Agent is responsible for:
- Running SQL Server tasks scheduled to occur at specific times or intervals.
- Detecting specific conditions for which administrators have defined an action, such as alerting someone through pages or e-mail, or a task that will address the conditions.
- Running replication tasks defined by administrators.
SQL Server Agent is similar to an auxiliary operator responsible for handling the repetitive tasks and exception handling conditions defined through the other SQL-DMF components.