Question

You manage 15 SQL Server 2022 instances running on Azure VMs. You want to define maintenance jobs once on a central server and have them automatically deployed and executed on all 15 instances, with job execution results reported back to the central server. Which SQL Server Agent feature should you configure?

Accepted Answer

Multiserver administration using a master server (MSX) and target servers (TSX)

Answer

An Azure Elastic Job agent targeting a server-level target group

Answer

A shared SQL Server Agent schedule referenced by jobs on each instance

Answer

SQL Server Agent proxy accounts mapped to a shared credential