Note
This view is available starting with V3.2.1.
Purpose
This view displays an overview of submitted tasks.
Applicability
This view is applicable only to OceanBase Database in Oracle mode.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| JOB | NUMBER(38) | NO | The task identifier. This parameter value remains unchanged after the task is imported, exported, or repeated. |
| LOG_USER | VARCHAR2(128) | NO | The login user when the task was submitted. |
| PRIV_USER | VARCHAR2(128) | NO | The user to which the default privileges apply. |
| SCHEMA_USER | VARCHAR2(128) | NO | The default schema user for parsing the task. |
| LAST_DATE | DATE | YES | The date when the task was last successfully executed. |
| LAST_SEC | VARCHAR2(32) | YES | The start time when the task was last successfully executed. |
| THIS_DATE | DATE | YES | The date when the task started to be executed. |
| THIS_SEC | VARCHAR2(32) | YES | The start time when the task was successfully executed. |
| NEXT_DATE | DATE | NO | The date when the task will be executed next. |
| NEXT_SEC | VARCHAR2(32) | YES | The start time when the task will be executed next. |
| TOTAL_TIME | NUMBER | YES | The total elapsed time (in seconds) spent by the system on the task since the task was first executed. This value is cumulative. |
| BROKEN | VARCHAR2(1) | YES | Specifies whether to run the task:
|
| INTERVAL | VARCHAR2(200) | NO | A date function. Records the time interval from the start time of the task to the start time of the next execution. |
| FAILURES | NUMBER(38) | YES | Records the number of successful and failed executions since the task was last successfully executed. |
| WHAT | VARCHAR2(4000) | YES | The body of the anonymous PL/SQL block that is executed for the task. |
| NLS_ENV | VARCHAR2(4000) | YES | The session parameters that describe the NLS environment of the task. |
| MISC_ENV | RAW(32) | YES | Other session parameters applicable to the task. |
| INSTANCE | VARCHAR2(128) | YES | The zone where the job runs. |