Synchronize Target Server Clocks (SQL Server Management Studio)

  • Article

 

Applies To: SQL Server

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

In This Topic

  • Before you begin:

    Security

  • To synchronize target server clocks, using:

    SQL Server Management Studio

    Transact-SQL

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).