Skip to content

Latest commit

 

History

History
41 lines (32 loc) · 3.37 KB

job-automation-overview.md

File metadata and controls

41 lines (32 loc) · 3.37 KB
title titleSuffix description author ms.author ms.reviewer ms.date ms.service ms.topic ms.custom dev_langs monikerRange
Automation in Azure SQL overview
Azure SQL Database & Azure SQL Managed Instance & Azure Synapse Analytics
Features for job automation to run Transact-SQL (T-SQL) scripts include elastic jobs on Azure SQL Database and SQL Agent jobs on Azure SQL Managed instance.
WilliamDAssafMSFT
wiassaf
srinia, mathoma
04/09/2024
sql-db-mi
conceptual
sqldbrb=1
TSQL
= azuresql || = azuresql-db || = azuresql-mi

Automate management tasks in Azure SQL

[!INCLUDE appliesto-sqldb-sqlmi-asa-ss]

This article summarizes job automation options in Azure SQL platforms, including Azure SQL Database, Azure SQL Database elastic pools, Azure SQL Managed Instance, and Azure Synapse Analytics.

Consider the following job scheduling and task automation technologies on different Azure SQL platforms:

Differences between SQL Agent and elastic jobs

The following table summarizes key differences between elastic jobs and SQL Agent:

Elastic jobs SQL Agent
Platform Azure SQL Database SQL Server, Azure SQL Managed Instance
Scope Any number of databases in Azure SQL Database only. Targets can be in different logical servers, subscriptions, and/or regions (dynamically enumerated at job runtime). Any individual database in the same instance as the SQL Agent.

The Multi Server Administration (MSX/TSX) feature of SQL Agent allows for master/target instances to coordinate job execution, though this feature is not available in SQL Managed Instance.
Supported APIs and tools T-SQL, PowerShell, REST APIs, Azure portal, Azure Resource Manager T-SQL, PowerShell, SQL Server Management Studio (SSMS)

Next step

[!div class="nextstepaction"] Elastic jobs in Azure SQL Database