Poll servers

Applies to: SQL Server

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.

When multiserver administration is implemented, target servers periodically contact the master server to upload information on jobs that have been executed, and download new jobs. The process of contacting the master server is called server polling, which takes place at regular polling intervals.

Polling intervals

The polling interval (one minute by default) controls how frequently the target server connects to the master server to download instructions and upload the results of job execution.

When a target server polls the master server, it reads the operations assigned to the target server from the dbo.sysdownloadlist table in the msdb database. These operations control multiserver jobs and various aspects of the behavior of a target server. Examples of operations include deleting a job, inserting a job, starting a job, and updating the polling interval of a target server.

Operations are posted to the dbo.sysdownloadlist table in either of the following ways:

  • Explicitly by using the dbo.sp_post_msx_operation stored procedure.

  • Implicitly by using other job stored procedures.

If you use job stored procedures to modify multiserver job schedules or job steps, or SQL Distributed Management Objects (SQL-DMO) to control multiserver jobs, issue the following command after modifying a multiserver job's steps or schedules:

EXECUTE msdb.dbo.sp_post_msx_operation 'INSERT', 'JOB', '<job id>'  

Issue this command keeps the target servers synchronized with the current job definition.

If you use the following items, you don't have to post operations explicitly:

  • Microsoft SQL Server Management Studio to control multiserver jobs.

  • Job stored procedures that don't modify job schedules or job steps.

Force a target server to poll the master server

See also