Auto Pause Setting up an ElasticJob Server on serverless
I have set up my main database server on Microsoft SQL Azure (Cloud).
This is up and running.
I need to run jobs at scheduled times. I believe I need to set an Elastic Job Agent.
I go through the steps to "Create Elastic Job Agent"
Under "Job Database" I "Create new" but it appears that choosing "Serverless" is a bit of a misnomer.
If I enable "Auto-Pause" (set any amount of time as a delay) then I can not add the Job Database as
"Auto-pause enabled serverless database isn't supported as a Job Database"
If I do not enable Auto-Pause then the deployment fails with a "Conflict )The service level objective 'SQLDB_GP_S_Gen5_1' does not support auto pause delay value '0' )"
How do I get over this?