Export (0) Print
Expand All

Manage Jobs Across an Enterprise

If you make changes to multiserver job definitions outside Microsoft SQL Server Management Studio, you must post the changes to the download list so that target servers can download the updated job again. To ensure that target servers have current job definitions, post an INSERT instruction after you update the multiserver job, as follows:

EXECUTE sp_post_msx_operation 'INSERT', 'JOB', '<job id>'

To notify target servers that a multiserver job has been modified, you must invoke the preceding command after using any of the following procedures:

The following are common tasks for managing jobs across an enterprise:

To check the status of a target server

To synchronize target server clocks

To force a target server to poll the master server

Community Additions

ADD
Show:
© 2014 Microsoft