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


VIEW: SYS.USER_SCHEDULER_DESTS

Object Details
Object Name: USER_SCHEDULER_DESTS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Destination objects for jobs in the database owned by current user

[View Source]

Columns
Name Datatype Length Mandatory Comments
DESTINATION_NAME VARCHAR2 (128) Yes Name of this destination object
DESTINATION_TYPE VARCHAR2 (8)
Type of this destination object
ENABLED VARCHAR2 (5)
Whether this destination object is enabled
COMMENTS VARCHAR2 (240)
Optional comment
Query Text

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


SELECT DESTINATION_NAME
,      DESTINATION_TYPE
,      ENABLED
,      COMMENTS
FROM SYS.USER_SCHEDULER_DESTS;

Dependencies

[top of page]

SYS.USER_SCHEDULER_DESTS references the following:

SchemaSYS
TableOBJ$
TableSCHEDULER$_DESTINATIONS
SYS.USER_SCHEDULER_DESTS is referenced by following:

SchemaPUBLIC
SynonymUSER_SCHEDULER_DESTS