Set the Polling Interval for Target Servers

Applies to: SQL Server Azure SQL Managed Instance

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 set the frequency that Microsoft SQL Server Agent refreshes information from the master to the target servers. A job is a specified series of actions that SQL Server Agent performs. A multiserver job is a job that a master server runs on one or more target servers.

Before You Begin

Each target server can run one instance of the same job at the same time. Each target server periodically polls the master server, downloads a copy of any new jobs assigned to the target server, and then disconnects. The target server runs the job locally and then reconnects to the master server to upload the job outcome status.

Note

If the master server is inaccessible when the target server tries to upload job status, the job status is spooled until the master server can be accessed.

Security

For detailed information, see Implement SQL Server Agent Security and Choose the Right SQL Server Agent Service Account for Multiserver Environments.

Using SQL Server Management Studio

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.

Using Transact-SQL

To set the polling interval for target servers

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

  2. On the toolbar, click New Query.

  3. In the query window, use the sp_post_msx_operation (Transact-SQL) system stored procedure to set the polling interval for target servers.

See Also

sysdownloadlist