Note
This view is available starting with V3.2.1.
Purpose
This view displays the running jobs.
Applicability
This view applies only to OceanBase Database in Oracle mode.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| SID | NUMBER | NO | The identifier of the process that is executing this job. |
| JOB | NUMBER | NO | The job identifier. |
| FAILURES | NUMBER | YES | The number of successful and failed executions of this job since the last successful execution. |
| LAST_DATE | DATE | YES | The date when this job was last successfully executed. |
| LAST_SEC | VARCHAR2(32) | NO | The start time of the last successful execution of this job. |
| THIS_DATE | DATE | YES | The date when this job started. |
| THIS_SEC | VARCHAR2(32) | NO | The start time of this job. |
| INSTANCE | VARCHAR2(128) | YES | The zone where the job is running. |