EnumHistory List

SQLServer.Executive.Task Object

Description

Lists the event history for this task. List is returned in a QueryResults object. Set the properties of a created HistoryFilter object as desired and pass it to the EnumHistory method.

Visual Basic

QueryResults = Task.EnumHistory ( [[HistoryFilter :=] HistoryFilter] )

C++

HRESULT pTask->EnumHistory (
LPSQLOLEQUERYRESULTS*
ppQueryResults,
LPSQLOLEHISTORYFILTER
HistoryFilter = NULL );

Elements

Element Type Description

QueryResults QueryResults Returned QueryResults object
HistoryFilter HistoryFilter HistoryFilter object

QueryResults

ColumnName ColumnType

id SQLOLE_DTypeInt4
eventid SQLOLE_DTypeInt4
messageid SQLOLE_DTypeInt4
severity SQLOLE_DTypeInt4
taskname SQLOLE_DTypeChar
source SQLOLE_DTypeChar
category SQLOLE_DTypeChar
runstatus SQLOLE_DTypeInt4
rundate SQLOLE_DTypeInt4
runtime SQLOLE_DTypeInt4
runduration SQLOLE_DTypeInt4
reviewstatus SQLOLE_DTypeChar
emailoperatorname SQLOLE_DTypeChar
retries SQLOLE_DTypeInt4
comments SQLOLE_DTypeChar
timesskipped SQLOLE_DTypeInt4

Reference

sp_helphistory