共用方式為


JobFilter.CurrentExecutionStatus 屬性

Gets or sets the job filter constraint that restricts the values returned by the JobServer object's EnumJobs method to the current execution status.

命名空間:  Microsoft.SqlServer.Management.Smo.Agent
組件:  Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
Public Property CurrentExecutionStatus As JobExecutionStatus 
    Get 
    Set
'用途
Dim instance As JobFilter 
Dim value As JobExecutionStatus 

value = instance.CurrentExecutionStatus

instance.CurrentExecutionStatus = value
public JobExecutionStatus CurrentExecutionStatus { get; set; }
public:
property JobExecutionStatus CurrentExecutionStatus {
    JobExecutionStatus get ();
    void set (JobExecutionStatus value);
}
member CurrentExecutionStatus : JobExecutionStatus with get, set
function get CurrentExecutionStatus () : JobExecutionStatus 
function set CurrentExecutionStatus (value : JobExecutionStatus)

屬性值

型別:Microsoft.SqlServer.Management.Smo.Agent.JobExecutionStatus
A JobExecutionStatus object value that specifies the current execution status constraint for the job filter.

備註

The job filter can be used to restrict the list returned by the JobServer object's EnumJobs method to jobs in a particular state of execution, such as "waiting for a worker thread" or "between retries".

範例

使用 SQL Server Agent 排程自動管理工作

請參閱

參考

JobFilter 類別

Microsoft.SqlServer.Management.Smo.Agent 命名空間

其他資源

自動化管理工作 (SQL Server Agent)