How to: Set the Polling Interval for Target Servers (SQL Server Management Studio)

This topic describes how to set the frequency that Microsoft SQL Server Agent refreshes information from the master to the target servers.

To set the polling interval for target servers

  1. In Object Explorer, connect to an instance of the 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. On the Target Server Status tab, click Post Instructions.

  4. In the Instruction type list, select Set polling interval.

  5. In the Polling interval box, enter the number of seconds from 10 through 28,800 that must pass before the target server polls the master server.

  6. Under Recipients, do one of the following:

    1. Click All target servers if all target servers share the same polling interval.
    2. Click These target servers if not all target servers share the same polling interval, and then select each target server that will use this polling interval.

See Also

Concepts

Automating Administration Across an Enterprise

Help and Information

Getting SQL Server 2005 Assistance