Export (0) Print
Expand All
Expand Minimize

sp_resync_targetserver (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Resynchronizes all multiserver jobs in the specified target server.

Applies to: SQL Server (SQL Server 2008 through current version).

Topic link icon Transact-SQL Syntax Conventions

     [ @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.

USE msdb ;

EXEC dbo.sp_resync_targetserver
    N'SEATTLE1' ;
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft