SQL Server Agent: Difference between revisions

Browse history interactively

← Previous edit

Content deleted Content added

VisualWikitext

Revision as of 00:38, 20 June 2015 edit Jdaloner (talk \| contribs) Extended confirmed users, Rollbackers 40,302 edits Removed "Windows Server System" cat tag since the category is for actual servers (not components thereof), and this is already properly listed in "Microsoft server technology" category. ← Previous edit		Latest revision as of 07:14, 1 April 2025 edit undo Citation bot (talk \| contribs) Bots 5,864,781 edits 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
(9 intermediate revisions by 6 users not shown)
Line 1: {{~~refimprove~~inline\|date=~~July~~March ~~2014~~2025}} '''SQL Server Agent''' is a component of [[Microsoft SQL Server]] which schedules jobs and handles other automated tasks.<ref>[~~http~~https://~~msdn~~docs.microsoft.com/en-us/~~library~~sql/~~ms189237.aspx~~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. Line 8 ⟶ 9: ==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]]