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_LOG

Object Details

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

Logged information for all scheduler jobs

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
LOG_ID	NUMBER		Yes	The unique id that identifies a row
LOG_DATE	TIMESTAMP(6) WITH TIME ZONE	(13)		The date of this 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)
JOB_CLASS	VARCHAR2	(128)		The class the job belonged to at the time of entry
OPERATION	VARCHAR2	(30)		The operation corresponding to this log entry
STATUS	VARCHAR2	(30)		The status of the operation, if applicable
USER_NAME	VARCHAR2	(128)		The name of the user who performed the operation, if applicable
CLIENT_ID	VARCHAR2	(64)		The client id of the user who performed the operation, if applicable
GLOBAL_UID	VARCHAR2	(32)		The global_uid of the user who performed the operation, if applicable
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 operation
ADDITIONAL_INFO	CLOB	(4000)		Additional information on this entry, if applicable

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT LOG_ID
,      LOG_DATE
,      OWNER
,      JOB_NAME
,      JOB_SUBNAME
,      JOB_CLASS
,      OPERATION
,      STATUS
,      USER_NAME
,      CLIENT_ID
,      GLOBAL_UID
,      CREDENTIAL_OWNER
,      CREDENTIAL_NAME
,      DESTINATION_OWNER
,      DESTINATION
,      ADDITIONAL_INFO
FROM SYS.DBA_SCHEDULER_JOB_LOG;

Dependencies

[top of page]

SYS.DBA_SCHEDULER_JOB_LOG references the following:

SYS: OBJ$; SCHEDULER$_EVENT_LOG

SYS.DBA_SCHEDULER_JOB_LOG is referenced by following:

PUBLIC: DBA_SCHEDULER_JOB_LOG
SYS: DBA_AUTOTASK_CLIENT; DBA_AUTOTASK_CLIENT_HISTORY