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.ALL_SCHEDULER_REMOTE_JOBSTATE

Object Details

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

Remote state of all jobs originating from this database visible to current user

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
OWNER	VARCHAR2	(128)	Yes	Owner of the scheduler job
JOB_NAME	VARCHAR2	(128)	Yes	Name of the scheduler job
DESTINATION	VARCHAR2	(512)	Yes	Name of job destination
STATE	VARCHAR2	(15)		State of job at remote system
NEXT_START_DATE	TIMESTAMP(6) WITH TIME ZONE	(13)		Next start date of job on remote system
RUN_COUNT	NUMBER			Run count of job on remote system
FAILURE_COUNT	NUMBER			Failure count of job on remote system
RETRY_COUNT	NUMBER
LAST_START_DATE	TIMESTAMP(6) WITH TIME ZONE	(13)		Last start time of job on remote system
LAST_END_DATE	TIMESTAMP(6) WITH TIME ZONE	(13)		Last end date of job on remote system

Query Text

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


SELECT OWNER
,      JOB_NAME
,      DESTINATION
,      STATE
,      NEXT_START_DATE
,      RUN_COUNT
,      FAILURE_COUNT
,      RETRY_COUNT
,      LAST_START_DATE
,      LAST_END_DATE
FROM SYS.ALL_SCHEDULER_REMOTE_JOBSTATE;

Dependencies

[top of page]

SYS.ALL_SCHEDULER_REMOTE_JOBSTATE references the following:

SYS: OBJ$; OBJAUTH$; SCHEDULER$_REMOTE_JOB_STATE; USER$

SYS.ALL_SCHEDULER_REMOTE_JOBSTATE is referenced by following:

PUBLIC: ALL_SCHEDULER_REMOTE_JOBSTATE