Share via

Elastic pool agent jobs with SQL server on azure vms

Ashwin Kumar 1 Reputation point
2021-06-03T16:22:11.287+00:00

I have a setup where I have sql server running in an azure vm. I would like to have my elastic pool agent connect to this server to run a few jobs. Is this supported at this time?

SQL Server on Azure Virtual Machines
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Martin Cairney 2,261 Reputation points
    2021-06-04T05:07:39.76+00:00

    I assume you mean Elastic Database Jobs Agent rather than "elastic pool agent"?

    At this time, Elastic Data base Jobs cannot run against SQL Server in an Azure VM so you'd need to consider other options - either Azure Automation or using SQL Agent on the instance of SQL Server in the Azure VM.

    I would suggest that the simplest approach would be using SQL Agent unless there are other dependencies, in which case Azure Automation may be the best approach.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.