SQL Server Agent
Product
A Windows service that runs scheduled jobs, alerts and notifications for SQL Server and Azure SQL Managed Instance.
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.
| Type | Product |
|---|---|
| Also known as | SQL Agent |
| Website | learn.microsoft.com/en-us/ssms/agent/sql-server-agent |
| Documentation | learn.microsoft.com/en-us/ssms/agent/sql-server-agent |
Articles about SQL Server Agent (1)
- Azure SQL Database vs. Fabric SQL Database: Cost and Compute Differences Explained
· Mirko Peters
Compare Azure SQL Database and Fabric SQL Database compute costs, serverless scaling, capacity units, storage economics, and feature trade-offs.
You should listen to thisMicrosoft Fabric OneLake - Simply Explained
Related topics in brief
- Microsoft · Developed by · Organization
Microsoft Corporation is a technology company that develops software and cloud services such as Microsoft 365, Azure and Dynamics 365. - Microsoft tool · Is a · Category
A software product or service developed by Microsoft. - Developer tool · Is a · Category
A tool that helps developers write, test and ship software. - Microsoft SQL Server · Related to · Product
Microsoft's relational database management system that uses T-SQL. Its engine also underpins Azure SQL Database and Azure SQL Managed Instance. - Azure SQL Managed Instance · Related to · Product
A managed Azure database option with close to full SQL Server compatibility, recommended by Microsoft for most migrations of existing SQL Server applications. - SQL Server Integration Services · Related to · Product
Microsoft's platform for data integration and ETL. It moves, cleans and transforms data with packages that run on SQL Server or in Azure. - Azure SQL Database · Related to · Product
Microsoft's managed relational database service in Azure. - Azure Monitor · Related to · Product
Azure's monitoring service that collects metrics and logs from cloud and on-premises resources; its log half is Log Analytics.
Developed by
- Microsoft · Organization
Is a
- Microsoft tool · Category
- Developer tool · Category
Related to
- Microsoft SQL Server · Product
- Azure SQL Managed Instance · Product
- SQL Server Integration Services · Product
- Azure SQL Database · Product
- Azure Monitor · Product
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.
Experts on related topics
- Mirko Peters · via Microsoft
Sources
- Official website: learn.microsoft.com/en-us/ssms/agent/sql-server-agent
- Documentation: learn.microsoft.com/en-us/ssms/agent/sql-server-agent
- Feed for this topic (RSS): entity/sql-server-agent/feed.xml
- Articles on this topic: 1
Maintained by Mirko Peters (Microsoft MVP) · Last updated: