FFS_DBM_STEP_RUN
DB Maintenance: Used to store a state of the currently executed task steps 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_STEP_RUN_PK |
STEP_RUN_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| STEP_RUN_ID | NUMBER | 19 | Yes | Step run id. generated by sequence. | |
| TASK_RUN_ID | NUMBER | 19 | Yes | Task run id. FK reference to DBM_TASK_RUN. | |
| STEP_LABEL | VARCHAR2 | 255 | Yes | Step name. List of steps is task specific and is supported in MS code. | |
| STATUS | VARCHAR2 | 30 | Yes | Contains status of the task step. Possible values: created, in_progress, completed, failed, suspended. | |
| STARTED_AT | TIMESTAMP | Contains start time of the task step run. | |||
| DURATION | NUMBER | 10 | Contains duration of the task step run, sec. | ||
| RUN_INFO | BLOB | Contains additional step run information. 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_STEP_RUN_N1 | Non Unique | DATA | TASK_RUN_ID, STEP_LABEL |
| FFS_DBM_STEP_RUN_PK | Unique | DATA | STEP_RUN_ID |