SQL Server Agent: Difference between revisions

Revision as of 01:36, 21 April 2014

Revision as of 20:12, 21 July 2014

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>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.