SQL Server Agent
Appearance
SQL Server Agent is a process which executes SQL Server jobs and handles other automated tasks. It runs as a [[Windows service] so can start automatically when the system boots or it can be started manually. It is a component of Microsoft SQL Server.
Typical system tasks performed include scheduling maintenance plans (such as backups), handling Reporting Services subscriptions and performing log-shipping sub-tasks. User tasks, such as scheduling some T-SQL or command line statement are also common.