The SelectStatsExecutionHistory external stored procedure displays the historical results from already completed calls to RunCollect or RecollectTable.
You can call RunCollectReport to monitor the results for an in-progress RunCollect.
Displaying Execution Results
| What to Display | Values to Specify |
|---|---|
| Results for a execution | RunID |
| Past execution results for a command list | CmdListID or CmdListName |
| Past execution results from collections on a user object | DatabaseName and TableName |
| Past execution results from collections on a named object list | ObjectListName that was previously created by the CreateObjectList and AddObjectListEntry external stored procedures. ObjectListName usage is mutually exclusive with DatabaseName and TableName . When you specify a value other than NULL for ObjectListName , DatabaseName and TableName must be NULL. |
| Execution results for a date range | StartTime and EndTime |