Note
This view was introduced in OceanBase Database V4.2.1.
Purpose
The DBA_SCHEDULER_JOB_RUN_DETAILS view displays all scheduler jobs in the current tenant.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| LOG_ID | NUMBER | NO | The log ID of the log record. At present, this column is not supported and its value is NULL by default.
NoteThis column was introduced in OceanBase Database V4.2.4. |
| LOG_DATE | TIMESTAMP(6) WITH TIME ZONE | NO | The log record.
NoteThis column was introduced in OceanBase Database V4.2.4. |
| OWNER | VARCHAR2(128) | NO | The owner of the job.
NoteThis column was introduced in OceanBase Database V4.2.4. |
| JOB_NAME | VARCHAR2(128) | NO | The name of the job.
NoteThis column was introduced in OceanBase Database V4.2.4. |
| JOB_SUBNAME | VARCHAR2(128) | NO | The subname of the job. At present, this column is not supported and its value is NULL by default.
NoteThis column was introduced in OceanBase Database V4.2.4. |
| STATUS | VARCHAR2(128) | NO | The status of the job.
NoteThis column was introduced in OceanBase Database V4.2.4. |
| CODE | NUMBER(38) | YES | The error code of the job running error. |
| REQ_START_DATE | TIMESTAMP(6) WITH TIME ZONE | NO | The expected start time of the job.
NoteThis column was introduced in OceanBase Database V4.2.4. |
| ACTUAL_START_DATE | TIMESTAMP(6) WITH TIME ZONE | NO | The actual start time of the job.
NoteThis column was introduced in OceanBase Database V4.2.4. |
| RUN_DURATION | NUMBER | NO | The duration of the job. At present, this column is not supported and its value is NULL by default.
NoteThis column was introduced in OceanBase Database V4.2.4. |
| INSTANCE_ID | VARCHAR2(128) | NO | At present, this column is not supported and its value is NULL by default.
NoteThis column was introduced in OceanBase Database V4.2.4. |
| SESSION_ID | NUMBER | NO | At present, this column is not supported and its value is NULL by default.
NoteThis column was introduced in OceanBase Database V4.2.4. |
| SLAVE_PID | VARCHAR2(128) | NO | The PID of the subprogress called by the job. At present, this column is not supported and its value is NULL by default.
NoteThis column was introduced in OceanBase Database V4.2.4. |
| CPU_USED | NUMBER | NO | The CPU utilization of the job. At present, this column is not supported and its value is NULL by default.
NoteThis column was introduced in OceanBase Database V4.2.4. |
| CREDENTIAL_OWNER | VARCHAR2(128) | NO | At present, this column is not supported and its value is NULL by default.
NoteThis column was introduced in OceanBase Database V4.2.4. |
| CREDENTIAL_NAME | VARCHAR2(128) | NO | At present, this column is not supported and its value is NULL by default.
NoteThis column was introduced in OceanBase Database V4.2.4. |
| DESTINATION_OWNER | VARCHAR2(128) | NO | At present, cross-database jobs are not supported, and the value of this column is NULL by default.
NoteThis column was introduced in OceanBase Database V4.2.4. |
| DESTINATION | VARCHAR2(128) | NO | At present, cross-database jobs are not supported, and the value of this column is NULL by default.
NoteThis column was introduced in OceanBase Database V4.2.4. |
| MESSAGE | VARCHAR2(4000) | NO | The error message of the job running error. |
| JOB | NUMBER(38) | NO | The name of the scheduler job. |
| TIME | TIMESTAMP(6) WITH LOCAL TIME ZONE | NO | The time when the job running log record was recorded. The value is a timestamp in seconds. |
| 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 last modified. The value is a timestamp in seconds. |
Sample query
obclient [SYS]> SELECT * FROM SYS.DBA_SCHEDULER_JOB_RUN_DETAILS WHERE ROWNUM = 1\G
The query result is as follows:
*************************** 1. row ***************************
LOG_ID: 0
LOG_DATE: NULL
OWNER: NULL
JOB_NAME: ASYNC_GATHER_STATS_JOB_PROC
JOB_SUBNAME: NULL
STATUS: NULL
CODE: 0
REQ_START_DATE: NULL
ACTUAL_START_DATE: NULL
RUN_DURATION: NULL
INSTANCE_ID: NULL
SESSION_ID: NULL
SLAVE_PID: NULL
CPU_USED: NULL
CREDENTIAL_OWNER: NULL
CREDENTIAL_NAME: NULL
DESTINATION_OWNER: NULL
DESTINATION: NULL
MESSAGE: SUCCESS
JOB: 9
TIME: 05-JUN-24 03.19.09.268015 PM
JOB_CLASS: DEFAULT_JOB_CLASS
GMT_CREATE: 05-JUN-24 03.19.09.268015 PM
GMT_MODIFIED: 05-JUN-24 03.19.09.268015 PM
1 row in set (0.008 sec)