PendingInstructions Property
Microsoft SQL Server의 이후 버전에서는 이 기능이 제거됩니다. 새 개발 작업에서는 이 기능을 사용하지 않도록 하고, 현재 이 기능을 사용하는 응용 프로그램은 수정하십시오.
The PendingInstructions property returns a count of SQL Server Agent target server maintenance tasks awaiting download by the target server.
구문
object.PendingInstructions
Parts
- object
An expression that evaluates to an object in the Applies To list
Data Type
Long
Modifiable
Read-only
Prototype (C/C++)
HRESULT GetPendingInstructions(LPLONG pRetVal);
주의
An instance of SQL Server acting as the master server for multiserver administration initiates tasks that create, modify, and delete jobs and job steps for target servers. Other tasks start or stop running jobs, coordinate polling, and so on. A target server polls its master server, retrieving and performing the tasks posted.
Due to polling, there is a lag between master server task assignment and its implementation by the target server. For example, a master server could delete a job step within a multiserver job. When the target server polls, it retrieves the task, an instruction to delete the job step, and the master server is altered, indicating that the pending instruction has been retrieved.