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.

See Also

DTS Overview

SQL Namespace API

SQL-DMO API

SQLServerAgent Service