Check Materialize View Refresh Schedule

SELECT job, what mview_name,

   TO_CHAR (last_date, 'mm/dd/yyyy hh24:mm:ss') last_execution,

   TO_CHAR (next_date, 'mm/dd/yyyy hh24:mm:ss') next_execution, INTERVAL

FROM dba_jobs

WHERE what LIKE ‘dbms_refresh.refresh%’;

Job

MVIEW_NAME

LAST_EXECUTION

NEXT_EXECUTION

INTERVAL

223

dbms_refresh.refresh(‘”SCOTT”.”ACCOUNT”‘);

07/22/2014 09:07:25

07/22/2014 10:07:25

SYSDATE + 1/24

126

dbms_refresh.refresh(‘”SCOTT”.”EMP”‘);

07/22/2014 09:07:00

07/22/2014 10:07:00

SYSDATE + 1/24

Post Views: 456

Related Posts