SQL Server Agent: Difference between revisions

Revision as of 20:17, 21 July 2014

Revision as of 07:08, 22 July 2014

Line 1:

{{unreferencedrefimprove|date=JuneJuly 20112014}}

'''SQL Server Agent''' is a component of [[Microsoft SQL Server]] which schedules jobs and handles other automated tasks.<ref>'SQL Server Agent' page on Microsoft Developer Network.[http://msdn.microsoft.com/en-us/library/ms189237.aspx 'SQL Server Agent' page on Microsoft Developer Network]</ref>. It runs as a [[Windows service]] so can start automatically when the [[Booting|system boots]] or it can be started manually.

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.

==References==

{{Reflist}}

[[Category:Relational database management systems]]