Syntax

object.PendingInstructions

Parts

object

Expression that evaluates to an object in the Applies To list

Data Type

Long

Modifiable

Read-only

Prototype (C/C++)

HRESULT GetPendingInstructions(LPLONG pRetVal);

Remarks

An instance of Microsoft SQL Server acting as the master server (MSX) for multiserver administration initiates tasks that create, modify, and delete jobs and job steps for target servers. Other tasks start or stop executing jobs, coordinate polling, and so on. A TSX polls its MSX, retrieving and performing the tasks posted.

Due to polling, there is a lag between MSX task assignment and its implementation by the target server. For example, an MSX could delete a job step within a multiserver job. When the TSX polls, it retrieves the task, an instruction to delete the job step, and the MSX is altered, indicating that the pending instruction has been retrieved.