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

Comments