Multiserver Job Management
Job management can be centralized on a single SQL Server, with other servers polling this server for the jobs they should run. In this situation, you configure a master server and define the jobs on this server. The next step is to enlist target servers, which periodically poll the master to see if they have jobs scheduled to run. This works if the servers are identical or similar in configuration. A job set to run on multiple servers to back up the sales database to drive F: will obviously fail if no sales database or drive F: exist on that server! By their nature, multiserver jobs must be generic.
Creating a Master SQL Server Agent
To create the Master Agent, right-click the SQL Server Agent folder from the server ...
Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
