Content deleted Content added
Initial Entry for SQL Server Agent |
Citation bot (talk | contribs) 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 |
||
| (36 intermediate revisions by 23 users not shown) | |||
Line 1:
{{inline|date=March 2025}}
'''SQL Server Agent''' is a component of [[Microsoft SQL Server]] which schedules jobs and handles other automated tasks.<ref>[https://docs.microsoft.com/en-us/sql/ssms/agent/sql-server-agent 'SQL Server Agent' page on Microsoft Developer Network]</ref> It runs as a [[Windows service]] so it 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.
SQLAgent has support for operators and alerts, so that administrators can be notified, e.g. by email.
==References==
{{Reflist}}
{{refbegin}}
:*{{cite book |last1=LeBlanc |first1=Patrick |title=Microsoft SQL Server 2012 Step by Step |date=15 February 2013 |publisher=[[Pearson Education]] |isbn=978-0-7356-7003-7 |url=https://books.google.com/books?id=Ua1CAwAAQBAJ |access-date=29 March 2025 |language=en}}
:*{{cite book |last1=Rankins |first1=Ray |last2=Bertucci |first2=Paul |last3=Gallelli |first3=Chris |last4=Silverstein |first4=Alex T. |title=Microsoft SQL Server 2012 Unleashed |date=9 December 2013 |publisher=[[Sams Publishing]] |isbn=978-0-13-340851-5 |url=https://books.google.com/books?id=NeBPAgAAQBAJ |language=en}}
{{refend}}
[[Category:Relational database management systems]]
[[Category:SQL]]
[[Category:Microsoft database software]]
[[Category:Microsoft server technology]]
{{Microsoft-software-stub}}
{{Database-software-stub}}
| |||