Materialized View Job SCHEDULER

During cutover activity there should not be any Materialized View Job in running state to avoid the delay. Below are the scripts to check the running MV’s and to stop the Jobs. Please note Materialized View Job name will start with MV. 1. SELECT * FROM DBA_SCHEDULER_RUNNING_JOBS; 2. BEGIN DBMS_SCHEDULER.STOP_JOB(job_name => 'MV_RF$J_0_S_116418', force => true); END; /