SQLServer Object
Lists SQL Server task history. 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 = SQLServer.EnumHistory ( [[HistoryFilter :=] HistoryFilter] )
HRESULT pSQLServer->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