The job scheduler for SQL Server, offered on SQL Server on VMs and SQL Managed Instance but not on Azure SQL Database.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains SQL Agent in context, with comparison tables and the common traps.
Terms in this definition
- Job scheduler
The scheduler built into Fabric that runs items like pipelines, notebooks and Dataflow Gen2 at chosen times. Each item may have more than one schedule, and you can set up notifications for failures.
- SQL Server
The relational database from Microsoft that organisations host and run themselves, in their own data centres or on VMs. Its engine also sits underneath the Azure SQL services and SQL database in Fabric.
- Virtual machines
Infrastructure-as-a-service compute giving complete control of the operating system, making it a fit for lift-and-shift moves and for software relying on OS-level pieces like COM.
- Serverless
Compute tier for single Azure SQL databases that scales automatically, pauses when idle and charges by the second. It is offered in General Purpose and Hyperscale, not Business Critical, and reserved capacity does not apply.
- Azure SQL Database
Platform-as-a-service database offered as a single database or in an elastic pool, sized up to 4 TB or 128 TB on Hyperscale. SQL Agent, CLR and queries across databases aren't available.
Related terms
- Azure SQL Managed Instance
Fully managed SQL Server instance offering almost complete compatibility, including SQL Agent, CLR and queries across databases; disaster recovery to another region is achieved with auto-failover groups.