eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: SYS.DBA_AUDIT_MGMT_CLEANUP_JOBS

Source

View Text - Preformatted


SELECT JOB_NAME,
       decode(JOB_STATUS,
              0, 'DISABLED',
              1, 'ENABLED',
                 'UNKNOWN'),
       decode(AUDIT_TRAIL_TYPE#,
              1, 'STANDARD AUDIT TRAIL',
              2, 'FGA AUDIT TRAIL',
              3, 'STANDARD AND FGA AUDIT TRAIL',
              4, 'OS AUDIT TRAIL',
              8, 'XML AUDIT TRAIL',
             12, 'OS AND XML AUDIT TRAIL',
             15, 'ALL AUDIT TRAILS',
             51, 'UNIFIED AUDIT TRAIL',
                 'UNKNOWN AUDIT TRAIL'),
       JOB_FREQUENCY,
       decode(bitand(job_flags, 1), 1, 'NO', 'YES'),
       decode(bitand(job_flags, 2), 2, 'ALL', 'CURRENT')
FROM DAM_CLEANUP_JOBS$

View Text - HTML Formatted

SELECT JOB_NAME
, DECODE(JOB_STATUS
, 0
, 'DISABLED'
, 1
, 'ENABLED'
, 'UNKNOWN')
, DECODE(AUDIT_TRAIL_TYPE#
, 1
, 'STANDARD AUDIT TRAIL'
, 2
, 'FGA AUDIT TRAIL'
, 3
, 'STANDARD
AND FGA AUDIT TRAIL'
, 4
, 'OS AUDIT TRAIL'
, 8
, 'XML AUDIT TRAIL'
, 12
, 'OS
AND XML AUDIT TRAIL'
, 15
, 'ALL AUDIT TRAILS'
, 51
, 'UNIFIED AUDIT TRAIL'
, 'UNKNOWN AUDIT TRAIL')
, JOB_FREQUENCY
, DECODE(BITAND(JOB_FLAGS
, 1)
, 1
, 'NO'
, 'YES')
, DECODE(BITAND(JOB_FLAGS
, 2)
, 2
, 'ALL'
, 'CURRENT') FROM DAM_CLEANUP_JOBS$