SQL Server Agent: Difference between revisions

Content deleted Content added
m Added a reference.
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
 
(13 intermediate revisions by 10 users not shown)
Line 1:
{{unreferencedinline|date=JuneMarch 20112025}}
 
'''SQL Server Agent''' is a component of [[Microsoft SQL Server]] which schedules jobs and handles other automated tasks.<ref>http[https://msdndocs.microsoft.com/en-us/librarysql/ms189237.aspxssms/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]]
Line 10 ⟶ 19:
[[Category:Microsoft database software]]
[[Category:Microsoft server technology]]
[[Category:Windows Server System]]