Question

You manage a SQL Server 2022 instance on an Azure VM. You have created six SQL Server Agent jobs that all must run nightly at 02:00. Business requirements state that if the maintenance window changes, you should be able to update all six jobs' start time in a single place without editing each job individually. What is the most efficient way to configure this?

Accepted Answer

Create one shared schedule and attach all six jobs to it.

Answer

Create six identical schedules, one per job, and edit them together using a T-SQL script when the window changes.

Answer

Combine all six jobs into a single job with six steps and give it one schedule.

Answer

Create a SQL Server Agent alert that fires at 02:00 and starts the six jobs.