Question

You are automating the setup of Elastic Jobs to run scheduled index maintenance across 40 Azure SQL databases. Your deployment pipeline uses the Azure CLI. Before you can create an Elastic Job agent named 'jobagent1', which prerequisite must the Azure CLI command reference, and how is it satisfied?

Accepted Answer

An existing Azure SQL Database to serve as the job database, referenced when creating the agent so it can store job definitions, execution history, and target group metadata

Answer

An existing Azure SQL Database that hosts the job metadata, passed via the --database argument when running 'az sql elastic-pool' commands

Answer

A SQL Server Agent service running on the logical server, enabled through 'az sql server update --enable-agent true'

Answer

An Azure Automation account linked to the logical server, referenced by resource ID during agent creation