Partager 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

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

Haut de la page

Public Properties

  Nom Description
ms219069.pubproperty(fr-fr,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(fr-fr,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(fr-fr,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(fr-fr,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(fr-fr,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(fr-fr,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(fr-fr,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(fr-fr,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(fr-fr,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(fr-fr,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.

Haut de la page

Public Methods

(see also Protected Methods )

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

Haut de la page

Protected Methods

  Nom Description
ms219069.protmethod(fr-fr,SQL.90).gif Finalize  (inherited from Object )
ms219069.protmethod(fr-fr,SQL.90).gif MemberwiseClone  (inherited from Object )

Haut de la page

Voir aussi

Référence

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

Autres ressources

Scheduling Automatic Administrative Tasks in SQL Server Agent
Automatisation des tâches administratives (SQL Server Agent)