Note
This view is available starting with V3.2.1.
Purpose
This view displays an overview of the submitted tasks.
Applicability
This view applies only to OceanBase Database in Oracle mode.
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| JOB | NUMBER(38) | NO | The task ID. The value of this parameter is not changed when you import or export a task or re-execute a task. |
| LOG_USER | VARCHAR2(128) | NO | The user who logged in when the task was submitted. |
| PRIV_USER | VARCHAR2(128) | NO | The user with default privileges for this task. |
| SCHEMA_USER | VARCHAR2(128) | NO | The default schema user for parsing this task. |
| LAST_DATE | DATE | YES | The date when this task was last successfully executed. |
| LAST_SEC | VARCHAR2(32) | YES | The start time when this task was last successfully executed. |
| THIS_DATE | DATE | YES | The date when this task was started. |
| THIS_SEC | VARCHAR2(32) | YES | The start time when this task was successfully executed. |
| NEXT_DATE | DATE | NO | The date when this task will be executed next. |
| NEXT_SEC | VARCHAR2(32) | YES | The start time when this task will be executed next. |
| TOTAL_TIME | NUMBER | YES | The total clock time (in seconds) spent by the system on this task since the task was first executed. The value is cumulative. |
| BROKEN | VARCHAR2(1) | YES | Whether to run this task: N: Run this taskY: Do not run this task |
| INTERVAL | VARCHAR2(200) | NO | The date function that records the time interval from the start time of this task to the start time of the next execution. |
| FAILURES | NUMBER(38) | YES | The number of successful and failed executions since the task was last successfully executed. |
| WHAT | VARCHAR2(4000) | YES | The body of the anonymous PL 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 for the task. |
| INSTANCE | VARCHAR2(128) | YES | The zone where the task can be executed or is being executed. The default value is an empty string. |
Views
DBA_JOBS