SQL Server Agent

SQL Server Agent runs on the server running Microsoft® SQL Server™. It 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 like an auxiliary operator that is responsible for handling the repetitive tasks and exception handling conditions defined through the other SQL-DMF components.

See Also