FFS_DBM_TASK_RUN
DB Maintenance: Used to store a state of the currently executed tasks as well as log records. This data is also used to resume long running tasks on restart of the service.
Details
-
Schema: FUSION
-
Object owner: FFS
-
Object type: TABLE
-
Tablespace: DATA
Primary Key
| Name | Columns |
|---|---|
|
FFS_DBM_TASK_RUN_PK |
TASK_RUN_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TASK_RUN_ID | NUMBER | 19 | Yes | Task run id. generated by sequence. | |
| TASK_LABEL | VARCHAR2 | 255 | Yes | Task name. List of supported tasks is in MS code. | |
| STATUS | VARCHAR2 | 30 | Yes | Contains current status of the task run. Possible values: created, in_progress, completed, failed, in_rollback, rolledback, suspended. | |
| UPDATED_AT | TIMESTAMP | When task status/progress was updated. | |||
| STARTED_AT | TIMESTAMP | Contains start time of the task run. | |||
| FINISHED_AT | TIMESTAMP | Contains time when the task was completed. | |||
| DURATION | NUMBER | 10 | Task run duration, w/o waits, sec. | ||
| CHANGED_ROWS | NUMBER | 10 | Contains number of changed rows by this task run. | ||
| TERMINATED_AT | TIMESTAMP | When task received terminate signal. | |||
| ROLLBACK_AT | TIMESTAMP | When rollback of the task was started. | |||
| ROLLBACK_DURATION | NUMBER | 10 | Task rollback run duration, sec. | ||
| RUN_PARAM | BLOB | Task parameters, json: e.g cut_date. | |||
| RUN_INFO | BLOB | Task run info, json: process/thread id, number of changed rows. | |||
| VALIDATION_INFO | BLOB | Contains additional task run validation info. Optional, in json format. | |||
| ERROR_INFO | BLOB | Error info, json: message/stack. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FFS_DBM_TASK_RUN_N1 | Non Unique | DATA | TASK_LABEL, STARTED_AT |
| FFS_DBM_TASK_RUN_PK | Unique | DATA | TASK_RUN_ID |