OWNER |
VARCHAR2(30) |
|
Owner of the Scheduler job |
JOB_NAME |
VARCHAR2(30) |
|
Name of the Scheduler job |
JOB_SUBNAME |
VARCHAR2(31) |
|
Subname of the Scheduler job |
CREDENTIAL_OWNER |
VARCHAR2(30) |
|
Owner of the credential used for the remote destination |
CREDENTIAL_NAME |
VARCHAR2(30) |
|
Name of the credential used for the remote destination |
DESTINATION_OWNER |
VARCHAR2(128) |
|
Owner of the destination object that points to the destination |
DESTINATION |
VARCHAR2(128) |
|
Name of the destination object or the name of the destination itself |
JOB_DEST_ID |
NUMBER |
|
Numerical ID assigned to the job at this destination |
ENABLED |
VARCHAR2(5) |
|
Indicates whether the parent job is enabled (TRUE) or disabled (FALSE) |
REFS_ENABLED |
VARCHAR2(5) |
|
Indicates whether this destination and its agent are enabled (TRUE) or disabled (FALSE) |
STATE |
VARCHAR2(15) |
|
State of this job at this destination:
-
DISABLED
-
RUNNING
-
CHAIN_STALLED
-
SCHEDULED
-
RETRY SCHEDULED
-
READY TO RUN
-
COMPLETED
-
BROKEN
-
FAILED
-
SUCCEEDED
-
REMOTE
-
STOPPED
|
NEXT_START_DATE |
TIMESTAMP(6) WITH TIME ZONE |
|
Next start time of this job at this destination |
RUN_COUNT |
NUMBER |
|
Number of times this job has run at this destination |
RETRY_COUNT |
NUMBER |
|
Number of times this job has been retried at this destination |
FAILURE_COUNT |
NUMBER |
|
Number of times this job has failed at this destination |
LAST_START_DATE |
TIMESTAMP(6) WITH TIME ZONE |
|
Last time this job started at this destination |
LAST_END_DATE |
TIMESTAMP(6) WITH TIME ZONE |
|
Last time this job ended at this destination |
