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