JobHistoryFilter Class

The JobHistoryFilter object is used to store information about the constraints applied to the EnumJobHistory method of the JobServer object.

Inheritance Hierarchy

System.Object
  Microsoft.SqlServer.Management.Smo.Agent.JobHistoryFilter

Namespace:  Microsoft.SqlServer.Management.Smo.Agent
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
Public NotInheritable Class JobHistoryFilter
'Usage
Dim instance As JobHistoryFilter
public sealed class JobHistoryFilter
public ref class JobHistoryFilter sealed
[<SealedAttribute>]
type JobHistoryFilter =  class end
public final class JobHistoryFilter

The JobHistoryFilter type exposes the following members.

Constructors

  Name Description
Public method JobHistoryFilter Initializes a new instance of the JobHistoryFilter class.

Top

Properties

  Name Description
Public property EndRunDate Gets or sets the job filter constraint that restricts the values returned by the JobServer object's EnumJobHistory method to the date the job completed running.
Public property JobID Gets or sets the job filter constraint that restricts the values returned by the JobServer object's EnumJobHistory method to the job specified by the job ID value.
Public property JobName Gets or sets the job filter constraint that restricts the values returned by the JobServer object's EnumJobHistory method to the job specified by the name of the job.
Public property MinimumRetries Gets or sets the job filter constraint that restricts the values returned by the JobServer object's EnumJobHistory method to jobs that have failed and been retried for minimum number of times specified.
Public property MinimumRunDuration Gets or sets the job filter constraint that restricts the values returned by the JobServer object's EnumJobHistory method to jobs that have completed running in the minimum length of time specified.
Public property OldestFirst Gets or sets the Boolean property value that specifies whether the jobs are listed in oldest-first order or in newest-first order.
Public property OutcomeTypes Gets or sets the job filter constraint that restricts the values returned by the JobServer object's EnumJobHistory method to jobs that have the specified outcome at completion.
Public property SqlMessageID Gets or sets the job filter constraint that restricts the values returned by the JobServer object's EnumJobHistory method to jobs that have generated the specified message during execution.
Public property SqlSeverity Gets or sets the job filter constraint that restricts the values returned by the JobServer object's EnumJobHistory method to jobs that have generated an error of the specified severity during execution.
Public property StartRunDate Gets or sets the job filter constraint that restricts the values returned by the JobServer object's EnumJobHistory method to the date the job started running.

Top

Methods

  Name Description
Public method Equals (Inherited from Object.)
Public method GetHashCode (Inherited from Object.)
Public method GetType (Inherited from Object.)
Public method ToString (Inherited from Object.)

Top

Remarks

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are safe for multithreaded operations. Any instance members are not guaranteed to be thread safe.

Examples

Calling Methods

Thread Safety

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

See Also

Reference

Microsoft.SqlServer.Management.Smo.Agent Namespace

Other Resources

Automated Administration Tasks (SQL Server Agent)