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.