SQL Server Agent: Difference between revisions

Revision as of 13:02, 31 July 2013

Revision as of 12:20, 27 August 2013

Line 1:

{{unreferenced|date=June 2011}}

'''SQL Server Agent''' is a a component of [[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 .

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.