Purpose
The DBA_SCHEDULER_JOB_RUN_DETAILS view displays all scheduler jobs in the tenant.
Note
This view is introduced since OceanBase Database V4.2.1.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TENANT_ID | NUMBER(38) | NO | The ID of the tenant. |
| JOB | NUMBER(38) | NO | The name of the scheduler job. |
| TIME | TIMESTAMP(6) WITH LOCAL TIME ZONE | NO | The running duration of the scheduler job, in seconds. |
| CODE | NUMBER(38) | YES | The code run by the scheduler job. |
| MESSAGE | VARCHAR2(4000) | NO | The running message of the scheduler job. |
| JOB_CLASS | VARCHAR2(30) | YES | The class of the scheduler job. |
| GMT_CREATE | TIMESTAMP(6) WITH LOCAL TIME ZONE | NO | The time when the scheduler job was created. The value is a timestamp in seconds. |
| GMT_MODIFIED | TIMESTAMP(6) WITH LOCAL TIME ZONE | NO | The time when the scheduler job was modified. The value is a timestamp in seconds. |