Jump to content

SQL Server Agent

Edit links
From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by Mogism (talk | contribs) at 21:07, 30 August 2013 (Cleanup/Typo fixing, typos fixed: a a → a using AWB). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

SQL Server Agent is a component of Microsoft SQL Server which schedules 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 .

Typical system tasks performed include scheduling maintenance plans (such as backups), handling 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.


Stub icon

This article about software created, produced or developed by Microsoft is a stub. You can help Wikipedia by expanding it.

Stub icon

This database software-related article is a stub. You can help Wikipedia by expanding it.

Retrieved from "https://en.wikipedia.org/w/index.php?title=SQL_Server_Agent&oldid=570861297"