sp_resync_targetserver (T-SQL)

Resynchronizes all multiserver jobs in the specified target server.

Syntax

sp_resync_targetserver [@server_name =] 'server'

Arguments

[@server_name =] 'server'

Is the name of the server to resynchronize. server is nvarchar(30), with no default. If ALL is specified, all target servers are resynchronized.

Return Code Values

0 (success) or 1 (failure)

Result Sets

Reports the result of sp_post_msx_operation actions.

Remarks

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. For more information about situations that may require using this stored procedure, see Troubleshooting Multiserver Jobs.

Permissions

Only members of the sysadmin fixed server role can execute sp_resync_targetserver.

Examples

This example resynchronizes the LONDON1 target server.

USE msdb

EXEC sp_resync_targetserver 'LONDON1'

See Also