JobFilter.CurrentExecutionStatus Property
Gets or sets the job filter constraint that restricts the values returned by the JobServer object's EnumJobs method to the current execution status.
Namespace: Microsoft.SqlServer.Management.Smo.Agent
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
Public Property CurrentExecutionStatus As JobExecutionStatus
Get
Set
'Usage
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)
Property Value
Type: Microsoft.SqlServer.Management.Smo.Agent.JobExecutionStatus
A JobExecutionStatus object value that specifies the current execution status constraint for the job filter.
Remarks
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".
Examples
Scheduling Automatic Administrative Tasks in SQL Server Agent
See Also
Reference
Microsoft.SqlServer.Management.Smo.Agent Namespace