SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2008 R2
Product Documentation
SQL Server 2008 R2 Books Online
Database Engine
Technical Reference
Transact-SQL Reference
System Stored Procedures (Transact-SQL)
SQL Server Agent Stored Procedures (Transact-SQL)
sp_add_alert (Transact-SQL)
sp_add_category (Transact-SQL)
sp_add_job (Transact-SQL)
sp_add_jobschedule (Transact-SQL)
sp_add_jobserver (Transact-SQL)
sp_add_jobstep (Transact-SQL)
sp_add_notification (Transact-SQL)
sp_add_operator (Transact-SQL)
sp_add_proxy (Transact-SQL)
sp_add_schedule (Transact-SQL)
sp_add_targetservergroup (Transact-SQL)
sp_add_targetsvrgrp_member (Transact-SQL)
sp_apply_job_to_targets (Transact-SQL)
sp_attach_schedule (Transact-SQL)
sp_cycle_agent_errorlog (Transact-SQL)
sp_cycle_errorlog (Transact-SQL)
sp_delete_alert (Transact-SQL)
sp_delete_category (Transact-SQL)
sp_delete_job (Transact-SQL)
sp_delete_jobschedule (Transact-SQL)
sp_delete_jobserver (Transact-SQL)
sp_delete_jobstep (Transact-SQL)
sp_delete_jobsteplog (Transact-SQL)
sp_delete_notification (Transact-SQL)
sp_delete_operator (Transact-SQL)
sp_delete_proxy (Transact-SQL)
sp_delete_schedule (Transact-SQL)
sp_delete_targetserver (Transact-SQL)
sp_delete_targetservergroup (Transact-SQL)
sp_delete_targetsvrgrp_member (Transact-SQL)
sp_detach_schedule (Transact-SQL)
sp_enum_login_for_proxy (Transact-SQL)
sp_enum_proxy_for_subsystem (Transact-SQL)
sp_enum_sqlagent_subsystems (Transact-SQL)
sp_grant_proxy_to_subsystem (Transact-SQL)
sp_grant_login_to_proxy (Transact-SQL)
sp_help_alert (Transact-SQL)
sp_help_category (Transact-SQL)
sp_help_downloadlist (Transact-SQL)
sp_help_job (Transact-SQL)
sp_help_jobactivity (Transact-SQL)
sp_help_jobcount (Transact-SQL)
sp_help_jobhistory (Transact-SQL)
sp_help_jobs_in_schedule (Transact-SQL)
sp_help_jobschedule (Transact-SQL)
sp_help_jobserver (Transact-SQL)
sp_help_jobstep (Transact-SQL)
sp_help_jobsteplog (Transact-SQL)
sp_help_notification (Transact-SQL)
sp_help_operator (Transact-SQL)
sp_help_proxy (Transact-SQL)
sp_help_schedule (Transact-SQL)
sp_help_targetserver (Transact-SQL)
sp_help_targetservergroup (Transact-SQL)
sp_manage_jobs_by_login (Transact-SQL)
sp_msx_defect (Transact-SQL)
sp_msx_enlist (Transact-SQL)
sp_msx_get_account (Transact-SQL)
sp_msx_set_account (Transact-SQL)
sp_notify_operator (Transact-SQL)
sp_post_msx_operation (Transact-SQL)
sp_purge_jobhistory (Transact-SQL)
sp_remove_job_from_targets (Transact-SQL)
sp_resync_targetserver (Transact-SQL)
sp_revoke_login_from_proxy (Transact-SQL)
sp_revoke_proxy_from_subsystem (Transact-SQL)
sp_start_job (Transact-SQL)
sp_stop_job (Transact-SQL)
sp_update_alert (Transact-SQL)
sp_update_category (Transact-SQL)
sp_update_job (Transact-SQL)
sp_update_jobschedule (Transact-SQL)
sp_update_jobstep (Transact-SQL)
sp_update_notification (Transact-SQL)
sp_update_operator (Transact-SQL)
sp_update_proxy (Transact-SQL)
sp_update_schedule (Transact-SQL)
sp_update_targetservergroup (Transact-SQL)
Expand Minimize
This topic has not yet been rated - Rate this topic

sp_resync_targetserver (Transact-SQL)

SQL Server 2008 R2

Resynchronizes all multiserver jobs in the specified target server.

Topic link icon Transact-SQL Syntax Conventions

Copy 

sp_resync_targetserver
     [ @server_name = ] 'server'
[ @server_name =] 'server'

The name of the server to resynchronize. server is sysname, with no default. If ALL is specified, all target servers are resynchronized.

0 (success) or 1 (failure)

Reports the result of sp_post_msx_operation actions.

sp_resync_targetserver deletes the current set of instructions for the target server and posts a new set for the target server to download. The new set consists of an instruction to delete all multiserver jobs, followed by an insert for each job currently targeted at the server.

Permissions to execute this procedure default to members of the sysadmin fixed server role.

The following example resynchronizes the SEATTLE1 target server.

Copy 
USE msdb ;
GO

EXEC dbo.sp_resync_targetserver
    N'SEATTLE1' ;
GO
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.