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%';
|
Check Materialize View Refresh Schedule
|