viewExecution
- Last UpdatedAug 23, 2024
- 1 minute read
This view returns a record-set of any data items (Dimensions or Measures) that are currently being executed (or processed) by the Runtime. Any data items that have already finished being executed by the Runtime are not returned. A large record-set, therefore, means that the Runtime is currently processing many data items.
|
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) |
|
Execution Source |
The Source of execution (SCHEDULER, EVENT, TDD) |
|
Runtime 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 Number 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 |
|
Last Modified Time |
The last time that the row was modified by the runtime service. |
Example:
Select * from [dbo].[viewExecution]