JobHistoryFilter Object

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.

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