Footprints Data Model |
Table |
Name | scheduled_task_run |
Comment |
An instance of a run for a schedule task used for last run and previous run information. The run date and the status of the run are kept here. There is only one row per run, so the time of each status change is not known. |
Column |
Name | Datatype | Comment | Is PK | Is FK |
schdd_task_run_id | bigint | The automatically generated primary key of the Scheduled Task Run table. | Yes | No |
schdd_task_id | bigint | A Foreign Key to the Scheduled Task table. | No | Yes |
schdd_task_status_id | integer |
The unique identifier for an instance of Scheduled Task Status. This identifier must be kept in sync with programming code that uses an enumeration or fixed constant to identify particular values. |
No | Yes |
status_chg_date | datetime | The date that the Scheduled Task Run was created. | No | No |
dtl_status | varchar(255) | The name of the Scheduled Task Run. | No | No |
schdd_run_date | datetime |   | No | No |