SQL Server Agent: Difference between revisions

Revision as of 12:57, 31 July 2013

Revision as of 13:02, 31 July 2013

Line 1:

{{unreferenced|date=June 2011}}

'''SQL Server Agent''' is a processa whichcomponent executesof [[Microsoft_SQL_Server|Microsoft SQL Server]] which schedules jobs and handles other automated tasks. It runs as a [[Windows_service|Windows service]] so can start automatically when the [[Booting|system boots]] or it can be started manually. It is a component of [[Microsoft SQL Server]].

Typical system tasks performed include scheduling maintenance plans (such as backups), handling [[SQL Server Reporting Services|Reporting Services]] subscriptions and performing [[log shipping]] sub-tasks (backup, copy, restore & check). User tasks, such as scheduling some [[T-SQL]] or command line statement are also common.

SQLAgent has support for operators and alerts, so that administrators can be notified, e.g. by email.

[[Category:Relational database management systems]]