Note
This view was introduced in version V4.2.1.
Purpose
The DBA_SCHEDULER_JOB_RUN_DETAILS view displays information about all scheduled jobs in the current tenant.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| LOG_ID | NUMBER | NO | The Log ID of the log entry. This field is not supported and defaults to NULL.
Note
|
| LOG_DATE | TIMESTAMP(6) WITH TIME ZONE | NO | The log entry.
Note
|
| OWNER | VARCHAR2(128) | NO | The owner of the job.
Note
|
| JOB_NAME | VARCHAR2(128) | NO | The name of the job.
Note
|
| JOB_SUBNAME | VARCHAR2(128) | NO | The subname of the job. This field is not supported and defaults to NULL.
Note
|
| STATUS | VARCHAR2(128) | NO | The status of the job.
Note
|
| CODE | NUMBER(38) | YES | The error code when the job fails. |
| REQ_START_DATE | TIMESTAMP(6) WITH TIME ZONE | NO | The expected start time of the job.
Note
|
| ACTUAL_START_DATE | TIMESTAMP(6) WITH TIME ZONE | NO | The actual start time of the job.
Note
|
| RUN_DURATION | NUMBER | NO | The runtime of the job. This field is not supported and defaults to NULL.
Note
|
| INSTANCE_ID | VARCHAR2(128) | NO | This field is not supported and defaults to NULL.
Note
|
| SESSION_ID | NUMBER | NO | This field is not supported and defaults to NULL.
Note
|
| SLAVE_PID | VARCHAR2(128) | NO | The PID of the subprocess that is invoked to execute the job. This field is not supported and defaults to NULL.
Note
|
| CPU_USED | NUMBER | NO | The CPU usage of the job. This field is not supported and defaults to NULL.
Note
|
| CREDENTIAL_OWNER | VARCHAR2(128) | NO | This field is not supported and defaults to NULL.
Note
|
| CREDENTIAL_NAME | VARCHAR2(128) | NO | This field is not supported and defaults to NULL.
Note
|
| DESTINATION_OWNER | VARCHAR2(128) | NO | This field is not supported for cross-database jobs and defaults to NULL.
Note
|
| DESTINATION | VARCHAR2(128) | NO | This field is not supported for cross-database jobs and defaults to NULL.
Note
|
| MESSAGE | VARCHAR2(4000) | NO | The error message returned when the job is run. |
| JOB | NUMBER(38) | NO | The name of the program job. |
| TIME | TIMESTAMP(6) WITH LOCAL TIME ZONE | NO | The time when the job runtime log is recorded, in seconds. |
| JOB_CLASS | VARCHAR2(30) | YES | The category of the program job. |
| GMT_CREATE | TIMESTAMP(6) WITH LOCAL TIME ZONE | NO | The time when the program job is created, in seconds. |
| GMT_MODIFIED | TIMESTAMP(6) WITH LOCAL TIME ZONE | NO | The time when the program job is modified, in seconds. |
Sample query
obclient [SYS]> SELECT * FROM SYS.DBA_SCHEDULER_JOB_RUN_DETAILS WHERE ROWNUM = 1\G
The sample 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)