viewMeasureBackfillStatus
- Last UpdatedAug 23, 2024
- 1 minute read
This view returns a record-set of any deployed measures. It includes the start and end of the entire backfill time-range, which consists of a list of execution "plans". It also includes the start and end of the individual plan that has last completed. Once the Backfill Status is set to 'Completed', the Measure has finished its backfill successfully.
|
Column |
Description |
|---|---|
|
Measure |
The name of the DataItem Measure |
|
DataItem Guid |
The Guid of the Data Item (Measure) |
|
Backfill Start-time (UTC) |
The start date and time of the total backfill |
|
Backfill End-time (UTC) |
The end date and time of the total backfill |
|
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 |
|
Backfill Status |
The current status of the Backfill (Pending, Completed, Suspended). If an error occurred during the backfill, then the status is suspended. |
|
Backfill TimeStamp |
The last time that the row was modified by the runtime service. |
Example:
Select * from [dbo].[viewMeasureBackfillStatus]