azureazure-sql-databaseazure-sql-managed-instanceazure-elasticpool

Elastic job agent should work with Azure Manage Instance database?


Actually In azure we are using Azure SQL Manage Instance. In or organization one MI server having similar 3 database with different name. Now we need to setup SQL jobs which run against all this three database. If we use SQL agent of MI then we need to setup three copy of each job for each db.

So, we are planning to setup elastic agent job to execute single job to run all this three dbs. If anyone having other approach then let me know. if we use this approach then elastic job agent should work with MI databases?


Solution

  • Actually, Elastic Database Jobs doesn't support Azure SQL managed instance.

    The following job scheduling technologies are available in Azure SQL Database:

    Please reference here: https://learn.microsoft.com/en-us/azure/sql-database/sql-database-job-automation-overview

    And for Azure SQL managed instance:

    Ref: Elastic Jobs in Azure SQL Database – What and Why

    Hope this helps.