M365Con 2027 – konferensi online gratis · 11–22 Jan 2027 · 120 sessions→ m365con.net

SQL Server Agent

Product

A Windows service that runs scheduled jobs, alerts and notifications for SQL Server and Azure SQL Managed Instance.

◆ PRODUCTSQL Server AgentM365.FM
Title graphic: SQL Server Agent (Product)

Description

SQL Server Agent is a Windows service that runs scheduled administrative tasks, called jobs, in SQL Server and Azure SQL Managed Instance. Job information is stored in SQL Server. A job has one or more steps, for example a T-SQL statement or the run of an SSIS package. Jobs can run on a schedule, in response to an alert or on demand.

The main parts are jobs, schedules, alerts and operators. Schedules define when a job runs, for example at agent startup, once at a set time or on a recurring basis. Alerts react to SQL Server events, performance conditions or WMI events and can notify operators or start a job. Operators are the contact data of people responsible for maintenance. Notifications use email, which needs Database Mail.

The page lists SQL Server and Azure SQL Managed Instance as supported platforms, and Managed Instance supports most but not all features. The service is off by default after installation unless autostart is chosen. Members of the sysadmin role and of the SQLAgent roles in msdb can use it. T-SQL steps run as the job owner, and other step types run under a proxy. Database administrators use it for routine maintenance.

TypeProduct
Also known asSQL Agent
Websitelearn.microsoft.com/en-us/ssms/agent/sql-server-agent
Documentationlearn.microsoft.com/en-us/ssms/agent/sql-server-agent

Articles about SQL Server Agent (2)

SQL Server AgentMicrosoftDeveloped byMicrosoft toolIs aDeveloper toolIs aMicrosoft SQL ServerRelated toAzure SQL Managed I…Related toSQL Server Integrat…Related toAzure SQL DatabaseRelated toAzure MonitorRelated to
Relationship map of SQL Server Agent: linked topics

Developed by

Is a

Related to

Glossary

Community wiki

Short info above, community knowledge below: add practical tips, examples or corrections. New contributions are reviewed first; trusted members publish directly.

Experts and companies for this topic

Nobody has listed this topic yet. Add it to your profile.

Sources

Maintained by Mirko Peters (Microsoft MVP) · Last updated: