SQLServer.Executive.Task Object
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.
QueryResults = Task.EnumHistory ( [[HistoryFilter :=] HistoryFilter] )
HRESULT pTask->EnumHistory (
LPSQLOLEQUERYRESULTS* ppQueryResults,
LPSQLOLEHISTORYFILTER HistoryFilter = NULL );
Element | Type | Description |
---|
QueryResults | QueryResults | Returned QueryResults object |
HistoryFilter | HistoryFilter | HistoryFilter object |
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 |
sp_helphistory