VIEW: SYS.DBA_AUTOTASK_CLIENT_JOB

Source

View Text - Preformatted

SELECT C.CNAME_KETCL AS CLIENT_NAME,
             TR.CURR_JOB_NAME AS JOB_NAME,
             SJ.STATE AS JOBS_SCHEDULER_STATUS,
             OP.PRG_KETOP AS TASK_NAME,
             TG.TNAME_KETTG AS TASK_TARGET_TYPE,
             TR.TARGET_NAME AS TASK_TARGET_NAME,
             DECODE(TR.TASK_PRIORITY,
                     1,'MEDIUM',
                     2,'HIGH',
                     3,'URGENT','INVALID') AS TASK_PRIORITY,
             OP.OPNAME_KETOP AS TASK_OPERATION
        FROM X$KETCL C, X$KETTG TG, X$KETOP OP, KET$_CLIENT_TASKS TR,
             DBA_SCHEDULER_JOBS SJ
       WHERE C.CID_KETCL = TR.CLIENT_ID
         AND C.CID_KETCL > 0
         AND OP.OPID_KETOP > 0
         AND (BITAND(C.ATTR_KETCL,2048) = 0
            OR 999999 < (SELECT TO_NUMBER(VALUE)
                           FROM V$SYSTEM_PARAMETER
                          WHERE NAME = '_automatic_maintenance_test'))
         AND C.CID_KETCL = OP.CID_KETOP
         AND TR.OPERATION_ID = OP.OPID_KETOP
         AND TR.CURR_JOB_NAME = SJ.JOB_NAME
         AND TR.TARGET_TYPE = TG.TID_KETTG

View Text - HTML Formatted

SELECT C.CNAME_KETCL AS CLIENT_NAME
, TR.CURR_JOB_NAME AS JOB_NAME
, SJ.STATE AS JOBS_SCHEDULER_STATUS
, OP.PRG_KETOP AS TASK_NAME
, TG.TNAME_KETTG AS TASK_TARGET_TYPE
, TR.TARGET_NAME AS TASK_TARGET_NAME
, DECODE(TR.TASK_PRIORITY
, 1
, 'MEDIUM'
, 2
, 'HIGH'
, 3
, 'URGENT'
, 'INVALID') AS TASK_PRIORITY
, OP.OPNAME_KETOP AS TASK_OPERATION
FROM X$KETCL C
, X$KETTG TG
, X$KETOP OP
, KET$_CLIENT_TASKS TR
, DBA_SCHEDULER_JOBS SJ
WHERE C.CID_KETCL = TR.CLIENT_ID
AND C.CID_KETCL > 0
AND OP.OPID_KETOP > 0
AND (BITAND(C.ATTR_KETCL
, 2048) = 0 OR 999999 < (SELECT TO_NUMBER(VALUE)
FROM V$SYSTEM_PARAMETER
WHERE NAME = '_AUTOMATIC_MAINTENANCE_TEST'))
AND C.CID_KETCL = OP.CID_KETOP
AND TR.OPERATION_ID = OP.OPID_KETOP
AND TR.CURR_JOB_NAME = SJ.JOB_NAME
AND TR.TARGET_TYPE = TG.TID_KETTG