question

AshwinKumar-0963 avatar image
0 Votes"
AshwinKumar-0963 asked MartinCairney-6481 answered

Elastic pool agent jobs with SQL server on azure vms

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?

azure-sql-virtual-machines
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

MartinCairney-6481 avatar image
0 Votes"
MartinCairney-6481 answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.