Auto Pause Setting up an ElasticJob Server on serverless

Chris Twinn 0 Reputation points
2025-04-23T08:50:51.93+00:00

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?

SQL Server Database Engine
0 comments No comments
{count} votes

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.