HistoryFilter Object Properties Collections
| Property | Description |
|---|
| Application Application Write: No |
The Application object. |
| CategoryName String Write: Yes |
The event category name to include. |
| CompletionTypes SQLOLE_COMPLETION_TYPE Write: Yes |
The types of task completions to include. |
| EndDate Date Write: Yes |
The date and time before which to include tasks. |
| EventID Long Write: Yes |
The event ID to include. |
| EventTypes SQLOLE_EVENT_TYPE Write: Yes |
The types of task events to include. |
| MessageID Long Write: Yes |
The message ID to include. |
| MinimumRetries Long Write: Yes |
The minimum number of retry attempts made for a task. |
| MinimumRunDuration Date Write: Yes |
The minimum length of time a task took to complete. |
| MinimumTimesSkipped Long Write: Yes |
The minimum number of times a task was skipped. |
| OldestFirst Boolean Write: Yes |
Determines if the list is sorted by the ascending time of task occurrence. If True, the oldest task is listed first. If False, the newest task is listed first. |
| Parent Application Write: No |
The Application object. |
| Severity Long Write: Yes |
The severity to include. |
| Source String Write: Yes |
The event source to include. |
| StartDate Date Write: Yes |
The date and time after which to include tasks. |
| TaskID Long Write: Yes |
The task ID to include. If you are not the system administrator and you are passing this to SQLServer.PurgeHistory, you must specify a task and you must be its owner. |
| TaskName Identifier Write: Yes |
The name of the task to include. If you are not the system administrator and you are passing this to SQLServer.PurgeHistory, you must specify a task and you must be its owner. |
| TypeOf SQLOLE_OBJECT_TYPE Write: No |
The type of object. |
| UserData Long Write: Yes |
Temporary storage space contained in this object for private use by the application. SQL-DMO does not use this property. |