共用方式為


JobHistoryFilter Members

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

  名稱 Description
JobHistoryFilter Initializes a new instance of the JobHistoryFilter class.

頂端

Public Properties

  名稱 Description
ms219069.pubproperty(zh-tw,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(zh-tw,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(zh-tw,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(zh-tw,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(zh-tw,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(zh-tw,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(zh-tw,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(zh-tw,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(zh-tw,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(zh-tw,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.

頂端

Public Methods

(see also Protected Methods )

  名稱 Description
ms219069.pubmethod(zh-tw,SQL.90).gif Equals  Overloaded. (inherited from Object )
ms219069.pubmethod(zh-tw,SQL.90).gif GetHashCode  (inherited from Object )
ms219069.pubmethod(zh-tw,SQL.90).gif GetType  (inherited from Object )
ms219069.pubmethod(zh-tw,SQL.90).gifms219069.static(zh-tw,SQL.90).gif ReferenceEquals  (inherited from Object )
ms219069.pubmethod(zh-tw,SQL.90).gif ToString  (inherited from Object )

頂端

Protected Methods

  名稱 Description
ms219069.protmethod(zh-tw,SQL.90).gif Finalize  (inherited from Object )
ms219069.protmethod(zh-tw,SQL.90).gif MemberwiseClone  (inherited from Object )

頂端

請參閱

參考

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

其他資源

Scheduling Automatic Administrative Tasks in SQL Server Agent
自動化管理工作 (SQL Server Agent)