Content deleted Content added
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. |
No edit summary |
||
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://msdn.microsoft.com/en-us/library/ms189237.aspx '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.
| |||