VIEW: SYS.USER_ILMRESULTS

Source

View Text - Preformatted

SELECT a.execution_id, a.jobname,
       DECODE(a.job_status, 1,'JOB CREATED',
                            2, 'COMPLETED SUCCESSFULLY',
                            3, 'FAILED',
                            4, 'STOPPED',
                            5, 'JOB CREATION FAILED',
                            6, 'JOB SCHEDULED',
                            7, 'JOB DISABLED',
                            8, 'JOB RUNNING',
                           10, 'DEPENDANT OBJECTS BEING REBUILT',
                           11, 'FAILED TO REBUILD DEPENDANT OBJECTS',
                           12, 'CREATING JOB',
                           13, 'JOB TO BE CREATED',
                               'NOT KNOWN'),
       a.start_time,
       a.completion_time,
       a.comments,
       a.statistics
  FROM sys.ilm_results$ a, sys.ilm_execution$ b
 WHERE a.execution_id = b.execution_id
   AND b.owner          = userenv('SCHEMAID')

View Text - HTML Formatted

SELECT A.EXECUTION_ID
, A.JOBNAME
, DECODE(A.JOB_STATUS
, 1
, 'JOB CREATED'
, 2
, 'COMPLETED SUCCESSFULLY'
, 3
, 'FAILED'
, 4
, 'STOPPED'
, 5
, 'JOB CREATION FAILED'
, 6
, 'JOB SCHEDULED'
, 7
, 'JOB DISABLED'
, 8
, 'JOB RUNNING'
, 10
, 'DEPENDANT OBJECTS BEING REBUILT'
, 11
, 'FAILED TO REBUILD DEPENDANT OBJECTS'
, 12
, 'CREATING JOB'
, 13
, 'JOB TO BE CREATED'
, 'NOT KNOWN')
, A.START_TIME
, A.COMPLETION_TIME
, A.COMMENTS
, A.STATISTICS
FROM SYS.ILM_RESULTS$ A
, SYS.ILM_EXECUTION$ B
WHERE A.EXECUTION_ID = B.EXECUTION_ID
AND B.OWNER = USERENV('SCHEMAID')