PendingInstructions Property
The PendingInstructions property returns a count of Microsoft® SQL Server™ 2000 Agent target server (TSX) maintenance tasks awaiting download by the target server.
Applies To
| TargetServer Object |
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.