Note
This view is available starting with V3.2.1.
Purpose
This view displays an overview of the 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 remains unchanged after the task is imported, exported, or repeated. |
| LOG_USER | VARCHAR2(128) | NO | The login user who submitted the task. |
| 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 of the last successful execution of the task. |
| THIS_DATE | DATE | YES | The date when the task started to be executed. |
| THIS_SEC | VARCHAR2(32) | YES | The start time of the successful execution of the task. |
| NEXT_DATE | DATE | NO | The date when the task will be executed next. |
| NEXT_SEC | VARCHAR2(32) | YES | The start time of the next execution of the task. |
| TOTAL_TIME | NUMBER | YES | The total wall-clock time spent on the task since its first execution, in seconds. This value is cumulative. |
| BROKEN | VARCHAR2(1) | YES | Indicates whether the task is running:
|
| INTERVAL | VARCHAR2(200) | NO | A date function. Records the time interval from the start time of the task's first execution to the start time of the next execution. |
| FAILURES | NUMBER(38) | YES | Records the number of successful and failed executions since the last successful execution of the task. |
| WHAT | VARCHAR2(4000) | YES | The body of the anonymous PL/SQL block that executes the task. |
| NLS_ENV | VARCHAR2(4000) | YES | The session parameters that describe the NLS environment of the task. |
| MISC_ENV | NULL | YES | Other session parameters applicable to the task. |
| INSTANCE | VARCHAR2(128) | YES | The zone where the task is executed or is being executed. This column is empty by default. |
References
DBA_JOBS