Export (0) Print
Expand All

Synchronize Target Server Clocks (SQL Server Management Studio)

This topic describes how to synchronize target server clocks in SQL Server 2012 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

Security

Permissions

Requires membership in the sysadmin fixed server role.

Arrow icon used with Back to Top link [Top]

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.

Arrow icon used with Back to Top link [Top]

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

Arrow icon used with Back to Top link [Top]

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft