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.