HistoryFilter Properties

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.