Question

You are designing an automated maintenance solution for 40 Azure SQL databases spread across three logical servers. You decide to use the Elastic Jobs feature to run parameterized T-SQL index maintenance against all targets on a nightly schedule. Before you can create the Elastic Job agent, what prerequisite resource must you provision?

Accepted Answer

A dedicated Azure SQL Database to serve as the job database for the Elastic Job agent

Answer

An Azure SQL Managed Instance to host the SQL Server Agent service

Answer

An Azure Automation account with a Hybrid Runbook Worker

Answer

An Azure Storage account configured with a database-scoped credential