Question

You manage 40 Azure SQL databases spread across three logical servers. You have configured an Elastic Job agent with a target group covering all databases and a T-SQL job that rebuilds indexes. The maintenance job must run automatically every night at 02:00. In the Elastic Job agent, which action correctly automates this recurring execution?

Accepted Answer

Add a schedule to the job by setting its schedule properties to a recurring interval (e.g., every 1 day) with a defined start time, and enable the schedule.

Answer

Create a SQL Server Agent job on each target database and configure a nightly schedule, since Elastic Job agents cannot run on a timer.

Answer

Configure an Azure Automation runbook that calls sp_start_job every night, because Elastic Jobs only support manual execution.

Answer

Set the job's output credential to a scheduled managed identity so the job triggers at the configured retention interval.