Hinweis
Für den Zugriff auf diese Seite ist eine Autorisierung erforderlich. Sie können versuchen, sich anzumelden oder das Verzeichnis zu wechseln.
Für den Zugriff auf diese Seite ist eine Autorisierung erforderlich. Sie können versuchen, das Verzeichnis zu wechseln.
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. |
Nach oben
Public Properties
| Name | Description | |
|---|---|---|
.gif "ms219069.pubproperty(de-de,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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
OldestFirst | Gets or sets the Boolean property value that specifies whether the jobs are listed in oldest-first order or in newest-first order. |
|
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. |
|
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. |
|
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. |
|
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. |
Nach oben
Public Methods
(see also Protected Methods )
| Name | Description | |
|---|---|---|
.gif "ms219069.pubmethod(de-de,SQL.90).gif") |
Equals | Overloaded. (inherited from Object ) |
|
GetHashCode | (inherited from Object ) |
|
GetType | (inherited from Object ) |
.gif "ms219069.static(de-de,SQL.90).gif") |
ReferenceEquals | (inherited from Object ) |
|
ToString | (inherited from Object ) |
Nach oben
Protected Methods
| Name | Description | |
|---|---|---|
.gif "ms219069.protmethod(de-de,SQL.90).gif") |
Finalize | (inherited from Object ) |
|
MemberwiseClone | (inherited from Object ) |
Nach oben
Siehe auch
Verweis
JobHistoryFilter Class
Microsoft.SqlServer.Management.Smo.Agent Namespace
Andere Ressourcen
Scheduling Automatic Administrative Tasks in SQL Server Agent
Automatisieren administrativer Tasks (SQL Server-Agent)