Jump to content

SQL Server Agent

From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by Ajoiner (talk | contribs) at 12:53, 31 July 2013. The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

SQL Server Agent is a process which executes SQL Server jobs and handles other automated tasks. It runs as a [[Windows service] so can start automatically when the 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 Reporting Services subscriptions and performing log-shipping sub-tasks. User tasks, such as scheduling some T-SQL or command line statement are also common.