Condividi tramite

JobHistoryFilter Members

  • Articolo

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

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

Torna all'inizio

Public Properties

  Nome Description
ms219069.pubproperty(it-it,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(it-it,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(it-it,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(it-it,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(it-it,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(it-it,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(it-it,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(it-it,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(it-it,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(it-it,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.

Torna all'inizio

Public Methods

(see also Protected Methods )

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

Torna all'inizio

Protected Methods

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

Torna all'inizio

Vedere anche

Riferimento

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

Altre risorse

Scheduling Automatic Administrative Tasks in SQL Server Agent
Automatizzazione delle attività amministrative (SQL Server Agent)