Purpose
The USER_JOBS view displays an overview of committed jobs.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Related views
DBA_JOBS
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| JOB | NUMBER(38) | NO | The identifier of the job. This parameter value remains unchanged when the job is imported, exported, or executed repeatedly. |
| LOG_USER | VARCHAR2(128) | NO | The user that submits the job. |
| PRIV_USER | VARCHAR2(128) | NO | The user whose default privileges apply to the job. |
| SCHEMA_USER | VARCHAR2(128) | NO | The default schema user for parsing the job. |
| LAST_DATE | DATE | YES | The date when the job was successfully executed the last time. |
| LAST_SEC | VARCHAR2(32) | YES | The time when the last successful execution started. |
| THIS_DATE | DATE | YES | The date when the job execution started. |
| THIS_SEC | VARCHAR2(32) | YES | The time when the job execution started. |
| NEXT_DATE | DATE | NO | The date when the next execution of the job is to be started. |
| NEXT_SEC | VARCHAR2(32) | YES | The time when the next execution of the job is to be started. |
| TOTAL_TIME | NUMBER | YES | The total clock time that the system spends on this task since its first execution, in seconds. This value is cumulative. |
| BROKEN | VARCHAR2(1) | YES | Indicates whether this job is run. Valid values: Y: This job is run.N: This job is not run. |
| INTERVAL | VARCHAR2(200) | NO | A date function. It indicates the interval between the start times of two consecutive executions. |
| FAILURES | NUMBER(38) | YES | The number of execution failures since the last successful execution of the job. |
| WHAT | VARCHAR2(4000) | YES | The body of the anonymous PL block that the job executes. |
| NLS_ENV | VARCHAR2(4000) | YES | A session parameter that describes the NLS environment of the job. |
| MISC_ENV | NULL | YES | Other session parameters that apply to this job. |
| INSTANCE | VARCHAR2(128) | YES | The zone where the task can be or is being executed. This parameter is left empty by default. |
