eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.DBA_SCHEDULER_JOB_RUN_DETAILS

Object Details

Object Name:	DBA_SCHEDULER_JOB_RUN_DETAILS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

The details of a job run

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
LOG_ID	NUMBER		Yes	The unique id of the log entry. Foreign key on entry in dba_scheduler_job_log
LOG_DATE	TIMESTAMP(6) WITH TIME ZONE	(13)		The date of the log entry
OWNER	VARCHAR2	(128)		The owner of the scheduler job
JOB_NAME	VARCHAR2	(261)		The name of the scheduler job
JOB_SUBNAME	VARCHAR2	(261)		The subname of the scheduler job (for a chain step job)
STATUS	VARCHAR2	(30)		The status of the job run
ERROR#	NUMBER			The error number in the case of error
REQ_START_DATE	TIMESTAMP(6) WITH TIME ZONE	(13)		The requested start date of the job run
ACTUAL_START_DATE	TIMESTAMP(6) WITH TIME ZONE	(13)		The actual date the job ran
RUN_DURATION	INTERVAL DAY(3) TO SECOND(0)	(11)		The duration that the job ran
INSTANCE_ID	NUMBER			The id of the instance on which the job ran
SESSION_ID	VARCHAR2	(128)		The session id of the job run
SLAVE_PID	VARCHAR2	(30)		The process id of the slave on which the job ran
CPU_USED	INTERVAL DAY(3) TO SECOND(2)	(11)		The amount of cpu used for this job run
CREDENTIAL_OWNER	VARCHAR2	(261)		Owner of the credential used for this external or remote job run
CREDENTIAL_NAME	VARCHAR2	(261)		Name of the credential used for this external or remote job run
DESTINATION_OWNER	VARCHAR2	(128)		Owner of destination object used in remote run or NULL if no object used
DESTINATION	VARCHAR2	(128)		The destination for a remote job run
ADDITIONAL_INFO	VARCHAR2	(4000)		Additional information on the job run, if applicable
ERRORS	VARCHAR2	(4000)		Text representation in db character set of errors from this job run
OUTPUT	VARCHAR2	(4000)		Text representation in db character set of output from this job run
BINARY_ERRORS	BLOB	(4000)		Errors from this job run, in their original form
BINARY_OUTPUT	BLOB	(4000)		Output from this job run, in its original form

Query Text

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.DBA_SCHEDULER_JOB_RUN_DETAILS;

Dependencies

[top of page]

SYS.DBA_SCHEDULER_JOB_RUN_DETAILS references the following:

SYS: DBMS_SCHEDULER - show dependent code; SCHEDULER$_EVENT_LOG; SCHEDULER$_JOB_OUTPUT; SCHEDULER$_JOB_RUN_DETAILS

SYS.DBA_SCHEDULER_JOB_RUN_DETAILS is referenced by following:

PUBLIC: DBA_SCHEDULER_JOB_RUN_DETAILS
SYS: DBA_AUTOTASK_CLIENT; DBA_AUTOTASK_JOB_HISTORY; DBMS_STREAMS_AUTO_INT - show dependent code; PRVT_ILM - show dependent code; _ALL_QUEUE_SCHEDULES; _DBA_QUEUE_SCHEDULES; _USER_QUEUE_SCHEDULES