Appearance
dbo.ethTaskSchedule_Deprecated
Info Generated by
scripts/Generate-DataDictionary.ps1- do not edit by hand. Edit descriptions inschemas/tables/dbo.ethTaskSchedule_Deprecated.jsonand regenerate.
Columns
| # | Column | Type | Nullable | Flags | Description |
|---|---|---|---|---|---|
| 1 | ID | int | no | identity | Identity primary key of the deprecated task schedule record. |
| 2 | Object | nvarchar(150) | no | Name of the object/task this schedule entry governed. | |
| 3 | PowerAutomateFlow | nvarchar(150) | no | Name of the Microsoft Power Automate flow that was triggered to run this task. | |
| 4 | ScheduleFrequency | int | no | Numeric interval between scheduled runs of the task (paired with ScheduleInterval to define the recurrence, e.g. every N minutes/hours). | |
| 5 | ScheduleInterval | nvarchar(50) | no | Unit of time for the recurrence interval (e.g. 'Minutes', 'Hours', 'Days'), used with ScheduleFrequency. | |
| 6 | NextTaskRun | datetime | no | Date and time the task is next due to run. | |
| 7 | LastRunStatusCode | int | no | Status/result code from the most recent run of the task's flow. | |
| 8 | LastRunStarted | datetime | yes | Date and time the most recent run of the task started. | |
| 9 | LastRunEnded | datetime | yes | Date and time the most recent run of the task ended. | |
| 10 | TaskInProgress | bit | no | Flag (1 = a run of this task is currently in progress), used to prevent overlapping runs. | |
| 11 | PowerAutomateURL | nvarchar(512) | yes | URL/webhook endpoint used to trigger the Power Automate flow for this task. | |
| 12 | LastRunID | nvarchar(512) | yes | Identifier of the most recent Power Automate flow run instance. | |
| 13 | LastRunFlowID | nvarchar(512) | yes | Identifier of the Power Automate flow definition used for the most recent run. | |
| 14 | Active | bit | no | Flag (1 = this schedule entry is active/enabled). |

