Microsoft® SQL Server 2012 Unleashed
by Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein
Multiserver Job Management
Multiserver job management allows you to centralize the administration of multiple target servers on a single master server. The master server is a SQL Server instance that contains the job definitions and status information for all the enlisted target servers. The target servers are SQL Server instances that obtain job information from the master server and continually update the master server with job statistics.
Multiserver job management is beneficial in SQL Server environments in which there are many instances to manage. You can establish jobs, operators, and execution schedules one time on the master server and then deploy them to all the target servers. This promotes consistency across the enterprise and can ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access