[Home] [Help] [Dependency Information]
Object Name: | USER_SCHEDULER_JOB_RUN_DETAILS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOG_ID | NUMBER | Yes | ||
LOG_DATE | TIMESTAMP(6) WITH TIME ZONE | (13) | ||
OWNER | VARCHAR2 | (128) | ||
JOB_NAME | VARCHAR2 | (261) | ||
JOB_SUBNAME | VARCHAR2 | (261) | ||
STATUS | VARCHAR2 | (30) | ||
ERROR# | NUMBER | |||
REQ_START_DATE | TIMESTAMP(6) WITH TIME ZONE | (13) | ||
ACTUAL_START_DATE | TIMESTAMP(6) WITH TIME ZONE | (13) | ||
RUN_DURATION | INTERVAL DAY(3) TO SECOND(0) | (11) | ||
INSTANCE_ID | NUMBER | |||
SESSION_ID | VARCHAR2 | (128) | ||
SLAVE_PID | VARCHAR2 | (30) | ||
CPU_USED | INTERVAL DAY(3) TO SECOND(2) | (11) | ||
CREDENTIAL_OWNER | VARCHAR2 | (261) | ||
CREDENTIAL_NAME | VARCHAR2 | (261) | ||
DESTINATION_OWNER | VARCHAR2 | (128) | ||
DESTINATION | VARCHAR2 | (128) | ||
ADDITIONAL_INFO | VARCHAR2 | (4000) | ||
ERRORS | VARCHAR2 | (4000) | ||
OUTPUT | VARCHAR2 | (4000) | ||
BINARY_ERRORS | BLOB | (4000) | ||
BINARY_OUTPUT | BLOB | (4000) |
Cut, paste (and edit) the following text to query this object:
SELECT LOG_ID
, LOG_DATE
, OWNER
, JOB_NAME
, JOB_SUBNAME
, STATUS
, ERROR#
, REQ_START_DATE
, ACTUAL_START_DATE
, RUN_DURATION
, INSTANCE_ID
, SESSION_ID
, SLAVE_PID
, CPU_USED
, CREDENTIAL_OWNER
, CREDENTIAL_NAME
, DESTINATION_OWNER
, DESTINATION
, ADDITIONAL_INFO
, ERRORS
, OUTPUT
, BINARY_ERRORS
, BINARY_OUTPUT
FROM SYS.USER_SCHEDULER_JOB_RUN_DETAILS;
|
|
|