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

VIEW: SYS.JOB$_CDB

Object Details
Object Name: JOB$_CDB
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
JOB NUMBER
Yes
LOWNER VARCHAR2 (128) Yes
POWNER VARCHAR2 (128) Yes
COWNER VARCHAR2 (128) Yes
LAST_DATE DATE

THIS_DATE DATE

NEXT_DATE DATE
Yes
TOTAL NUMBER
Yes
INTERVAL# VARCHAR2 (200) Yes
FAILURES NUMBER

FLAG NUMBER
Yes
WHAT VARCHAR2 (4000)
NLSENV VARCHAR2 (4000)
ENV RAW (32)
CHARENV VARCHAR2 (4000)
FIELD1 NUMBER

SCHEDULER_FLAGS NUMBER

XID VARCHAR2 (40)
CON_ID NUMBER

container id
Query Text

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


SELECT JOB
,      LOWNER
,      POWNER
,      COWNER
,      LAST_DATE
,      THIS_DATE
,      NEXT_DATE
,      TOTAL
,      INTERVAL#
,      FAILURES
,      FLAG
,      WHAT
,      NLSENV
,      ENV
,      CHARENV
,      FIELD1
,      SCHEDULER_FLAGS
,      XID
,      CON_ID
FROM SYS.JOB$_CDB;

Dependencies

[top of page]

SYS.JOB$_CDB does not reference any database object

SYS.JOB$_CDB is not referenced by any database object