Edit

Share via

Synchronize Target Server Clocks

  • Article

Applies to: SQL Server

Important

On Azure SQL Managed Instance, most, but not all SQL Server Agent features are currently supported. See Azure SQL Managed Instance T-SQL differences from SQL Server for details.

This topic describes how to synchronize target server clocks in SQL Server with the master server clock by using SQL Server Management Studio or Transact-SQL. Synchronizing these system clocks supports your job schedules.

Before You Begin

Security

Permissions

Requires membership in the sysadmin fixed server role.

Using SQL Server Management Studio

To synchronize target server clocks

  1. In Object Explorer, click the plus sign to expand the server where you want to synchronize the target server clocks with the master server clock.

  2. Right-click SQL Server Agent, point to Multi Server Administration, and select Manage Target Servers.

  3. In the Manage Target Servers dialog box, click Post Instructions.

  4. In the Instruction type list, select Synchronize clocks.

  5. Under Recipients, do one of the following:

    • Click All target servers to synchronize all target server clocks with the master server clock.

    • Click These target servers to synchronize certain server clocks, and then select each target server whose clock you want to synchronize with the master server clock.

  6. When finished, click OK.

Using Transact-SQL

To synchronize target server clocks

  1. In Object Explorer, connect to an instance of Database Engine.

  2. On the Standard bar, click New Query.

  3. Copy and paste the following example into the query window and click Execute.

    USE msdb ;  
GO  
-- resynchronizes the SEATTLE1 target server  
EXEC dbo.sp_resync_targetserver  
    N'SEATTLE1' ;  
GO

For more information, see sp_resync_targetserver (Transact-SQL).