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

VIEW: SYS.JOB$_REDUCED

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

[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)
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
FROM SYS.JOB$_REDUCED;

Dependencies

[top of page]

SYS.JOB$_REDUCED references the following:

SchemaSYS
TableJOB$

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