Feature
DBA_JOBS_RUNNING displays the running jobs.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Fields
| Field | Type | Nullable | Description |
|---|---|---|---|
| SID | NUMBER | NO | The identifier of the process that is executing this job. |
| JOB | NUMBER | NO | The identifier of the job. |
| FAILURES | NUMBER | YES | The number of execution failures since the last successful execution of the job. |
| LAST_DATE | DATE | YES | The date when the job was successfully executed the last time. |
| LAST_SEC | VARCHAR2(32) | NO | The time when the last successful execution started. |
| THIS_DATE | DATE | YES | The date when the job execution started. |
| THIS_SEC | VARCHAR2(32) | NO | The time when the job execution started. |
| INSTANCE | VARCHAR2(128) | YES | The zone where the job runs. |