Ovaj preglednik više nije podržan.
Nadogradite na Microsoft Edge da iskoristite najnovije osobine, sigurnosna ažuriranja i tehničku podršku.
Bilješka
Pristup ovoj stranici zahtijeva provjeru vjerodostojnosti. Možete pokušati da se prijavite ili promijenite direktorije.
Pristup ovoj stranici zahtijeva provjeru vjerodostojnosti. Možete pokušati promijeniti direktorije.
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
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:
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) |
Obučavanje
Certifikacija
Microsoft Certified: Azure Database Administrator Associate - Certifications
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.