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