SQL Server Agent

From Wikipedia, the free encyclopedia
This is the current revision of this page, as edited by imported>Citation bot at 07:14, 1 April 2025 (Altered url. URLs might have been anonymized. | Use this bot. Report bugs. | Suggested by Abductive | Category:Articles lacking in-text citations from March 2025 | #UCB_Category 343/690). The present address (URL) is a permanent link to this version.
(diff) ← Previous revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

SQL Server Agent is a component of Microsoft SQL Server which schedules jobs and handles other automated tasks.[1] It runs as a Windows service so it can start automatically when the system boots or it can be started manually.

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.

References

[edit | edit source]
  1. ^ 'SQL Server Agent' page on Microsoft Developer Network
  • Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
  • Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).


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 "http://70.231.62.181/index.php?title=SQL_Server_Agent&oldid=169914"