DBA Data[Home] [Help]

VIEW: SYS.DBA_WI_JOBS

Source

View Text - Preformatted

select j.jobid,
       j.jobname,
       j.path,
       m.modelorder,
       m.threshold
from wi$_job j,
     wi$_frequent_pattern_metadata m
where j.jobid = m.jobid (+)
View Text - HTML Formatted

SELECT J.JOBID
, J.JOBNAME
, J.PATH
, M.MODELORDER
, M.THRESHOLD FROM WI$_JOB J
, WI$_FREQUENT_PATTERN_METADATA M WHERE J.JOBID = M.JOBID (+)