Compartilhar via


How to: Synchronize Target Server Clocks (SQL Server Management Studio)

This topic explains how to synchronize target server clocks with the master server clock. Synchronizing these system clocks supports your job schedules.

To synchronize target server clocks

  1. In Object Explorer, connect to an instance of the Microsoft SQL Server Database Engine, and then expand that instance.

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

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

See Also

Concepts

Automating Administration Across an Enterprise

Help and Information

Getting SQL Server 2005 Assistance