JobHistoryFilter Object

  • Article

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The JobServer object exposes a JobHistoryFilter object. The JobHistoryFilter object does not represent a Microsoft SQL Server component. It is used to control JobServer object methods. If used as a parameter to the EnumJobHistory method, a JobHistoryFilter object constrains the output of the method. If used with the PurgeJobHistory method, the JobHistoryFilter object restricts the scope of the method.

SQL-DMO object model that shows the current object

Properties

EndRunDate Property

OldestFirst Property

EndRunTime Property

OutcomeTypes Property

JobID Property

SQLMessageID Property

JobName Property

SQLSeverity Property

MinimumRetries Property

StartRunDate Property

MinimumRunDuration Property

StartRunTime Property

See Also

Reference

EnumJobHistory Method
PurgeJobHistory Method

Help and Information

Getting SQL Server 2005 Assistance