Revision as of 18:52, 24 April 2018 edit Sphilbrick (talk \| contribs) Administrators 180,483 edits Reverted good faith edits by Mgroberts95 (talk): Copyright issue re https://docs.microsoft.com/en-us/sql/ssms/agent/sql-server-agent?view=sql-server-2017. (TW) Tag: Undo ← Previous edit		Revision as of 17:14, 15 January 2020 edit undo Wibeasley (talk \| contribs) 12 edits m update link to Microsoft site Next edit →
Line 1: {{refimprove\|date=July 2014}} '''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.

SQL Server Agent: Difference between revisions