viewExecutionHistory
- Last UpdatedJan 30, 2019
- 1 minute read
This view returns a record-set of any data items (Dimensions or Measures) that have finished execution (or processing) by the Runtime. It also includes those data items that have started processing.
Note: This view will only have data if EnableExecutionHistory is set to true in EMIRuntimeConfigurator.xml, located at Intelligence\bin. For more information, refer to the Performance Settings.
|
Column |
Description |
|---|---|
|
ExecutionId |
The autogenerated Execution-ID |
|
DataItem |
The name of the Data Item (Dimension or Measure) |
|
DataItem Guid |
The Guid of the Data Item (Dimension or Measure) |
|
Source |
The Source of execution (SCHEDULER, EVENT, TDD) |
|
Last Modified |
The last time that the row was modified by the runtime service. |
|
Thread Id |
The runtime service internal Thread Id |
|
Start-time (UTC) |
The start date and time for execution |
|
End-time (UTC) |
The end date and time for execution |
|
Total No. of Execution Plans |
The calculated total number of execution plans for the time range of start and end-time. |
|
Current Plan Start-time (UTC) |
The last execution plan's start time |
|
Current Plan End-time (UTC) |
The last execution plan's end time |
|
Execution Status |
The current execution status |
|
Execution TimeStamp |
The date and time when the execution request was added |
|
History TimeStamp |
The last time that the row was modified by the runtime service. |
Example:
Select * from [dbo].[viewExecutionHistory]