VIEW: SYS.USER_ADVISOR_EXECUTIONS

Source

View Text - Preformatted

select t.id           as task_id,
            t.name         as task_name,
            e.name         as execution_name,
            e.id           as execution_id,
            e.description  as description,
            e.exec_type    as execution_type,
            e.exec_start   as execution_start,
            e.exec_mtime   as execution_last_modified,
            e.exec_end     as execution_end,
            t.advisor_name as advisor_name,
            e.advisor_id   as advisor_id,
            decode(e.status, 2, 'EXECUTING',
                             3, 'COMPLETED',
                             4, 'INTERRUPTED',
                             5, 'CANCELLED',
                             6, 'FATAL ERROR') as status,
            e.status       as status#,
            nvl2(e.status_msg_id,
                 dbms_advisor.format_message_group(e.status_msg_id),
                 NULL) as status_message,
            nvl2(e.error_msg_id,
                 dbms_advisor.format_message_group(e.error_msg_id),
                 NULL) as error_message
     from wri$_adv_executions e, wri$_adv_tasks t
     where e.task_id = t.id and e.advisor_id = t.advisor_id and
           t.owner# = userenv('SCHEMAID')

View Text - HTML Formatted

SELECT T.ID AS TASK_ID
, T.NAME AS TASK_NAME
, E.NAME AS EXECUTION_NAME
, E.ID AS EXECUTION_ID
, E.DESCRIPTION AS DESCRIPTION
, E.EXEC_TYPE AS EXECUTION_TYPE
, E.EXEC_START AS EXECUTION_START
, E.EXEC_MTIME AS EXECUTION_LAST_MODIFIED
, E.EXEC_END AS EXECUTION_END
, T.ADVISOR_NAME AS ADVISOR_NAME
, E.ADVISOR_ID AS ADVISOR_ID
, DECODE(E.STATUS
, 2
, 'EXECUTING'
, 3
, 'COMPLETED'
, 4
, 'INTERRUPTED'
, 5
, 'CANCELLED'
, 6
, 'FATAL ERROR') AS STATUS
, E.STATUS AS STATUS#
, NVL2(E.STATUS_MSG_ID
, DBMS_ADVISOR.FORMAT_MESSAGE_GROUP(E.STATUS_MSG_ID)
, NULL) AS STATUS_MESSAGE
, NVL2(E.ERROR_MSG_ID
, DBMS_ADVISOR.FORMAT_MESSAGE_GROUP(E.ERROR_MSG_ID)
, NULL) AS ERROR_MESSAGE
FROM WRI$_ADV_EXECUTIONS E
, WRI$_ADV_TASKS T
WHERE E.TASK_ID = T.ID
AND E.ADVISOR_ID = T.ADVISOR_ID AND T.OWNER# = USERENV('SCHEMAID')