Share via

JobHistoryFilter Members

  • Article

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

The following tables list the members exposed by the JobHistoryFilter type.

Public Constructors

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

Top

Public Properties

  Name Description
ms219069.pubproperty(en-US,SQL.90).gif 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.
ms219069.pubproperty(en-US,SQL.90).gif 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.
ms219069.pubproperty(en-US,SQL.90).gif 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.
ms219069.pubproperty(en-US,SQL.90).gif 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.
ms219069.pubproperty(en-US,SQL.90).gif 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.
ms219069.pubproperty(en-US,SQL.90).gif OldestFirst Gets or sets the Boolean property value that specifies whether the jobs are listed in oldest-first order or in newest-first order.
ms219069.pubproperty(en-US,SQL.90).gif 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.
ms219069.pubproperty(en-US,SQL.90).gif 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.
ms219069.pubproperty(en-US,SQL.90).gif 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.
ms219069.pubproperty(en-US,SQL.90).gif 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

Public Methods

(see also Protected Methods )

  Name Description
ms219069.pubmethod(en-US,SQL.90).gif Equals  Overloaded. (inherited from Object )
ms219069.pubmethod(en-US,SQL.90).gif GetHashCode  (inherited from Object )
ms219069.pubmethod(en-US,SQL.90).gif GetType  (inherited from Object )
ms219069.pubmethod(en-US,SQL.90).gifms219069.static(en-US,SQL.90).gif ReferenceEquals  (inherited from Object )
ms219069.pubmethod(en-US,SQL.90).gif ToString  (inherited from Object )

Top

Protected Methods

  Name Description
ms219069.protmethod(en-US,SQL.90).gif Finalize  (inherited from Object )
ms219069.protmethod(en-US,SQL.90).gif MemberwiseClone  (inherited from Object )

Top

See Also

Reference

JobHistoryFilter Class
Microsoft.SqlServer.Management.Smo.Agent Namespace

Other Resources

Scheduling Automatic Administrative Tasks in SQL Server Agent
Automating Administrative Tasks (SQL Server Agent)