SQL Server Agent

Definition of SQL Server Agent in The Network Encyclopedia.

What is SQL Server Agent?

A collection of managers for Microsoft SQL Server 7. Called SQL Executive in version 6 of SQL Server, SQL Server Agent handles repetitive tasks and exception conditions.

SQL Server Agent allows you to:

  • Schedule and automate administrative tasks to run at specific times or time intervals.
  • Send alerts to administrators when error conditions arise, such as a database running out of space. You can use e-mail or pagers for alerting purposes, or you can trigger a job to run.
  • Perform replication tasks that have been specified by administrators.

See also: