Content deleted Content added
m Added a reference. |
Added source name to reference. |
||
Line 1:
{{unreferenced|date=June 2011}}
'''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]</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.
| |||