Purpose
This view displays an overview of all tasks submitted by the current user.
Applicability
This view is available only in Oracle mode of OceanBase Database.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| JOB | NUMBER(38) | NO | The task identifier. This value remains unchanged after the task is imported, exported, or re-executed. |
| 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 for this task. |
| 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 executing. |
| 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 (in seconds) spent on the task since its first execution. This value is cumulative. |
| BROKEN | VARCHAR2(1) | YES | Indicates whether the task is running: N: The task is running.Y: The task is not 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 executed by the task. |
| NLS_ENV | VARCHAR2(4000) | YES | Session parameters that describe the NLS environment of the task. |
| MISC_ENV | NULL | YES | Other session parameters applicable to this 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