The PendingInstructions property returns a count of SQL Server Agent target server maintenance tasks awaiting download by the target server.
object.PendingInstructions
| Part | Description |
|---|---|
| object | Expression that evaluates to an object in the Applies To list |
A Microsoft® SQL Server™ installation acting as the MSX for multiserver administration initiates tasks that create, modify, and delete jobs and job steps for targets. Other tasks start or stop executing jobs, coordinate polling, and so on. A target server 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. For example, an MSX could delete a job step within a multiserver job. When the target 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.
Long
Read-only
HRESULT GetPendingInstructions(LPLONG pRetVal);