Materialized view check

materialized views: Materialized view check.sql

set verify off
set trimspool on
set lines 132
set pages 10000
set markup html on;
set linesize 300
col INSTANCE_NAME format a10
col HOST_NAME format a30
col JOB format 9999999999
col SCHEMA_USER format a30
col LAST_DATE format 999999
col NEXT_DATE format 999999
col broken format a10
col INTERVAL format 999999
col what format a100
alter session set nls_date_format='dd/mm/yyyy hh24:mi:ss';
spool /home/oracle/scripts/prod1/MV_Check/mv.txt
select INSTANCE_NAME INSTANCE,HOST_NAME,job,schema_user,last_date,next_date,broken,INTERVAL,what
             from dba_jobs,v$instance where last_date < sysdate - 1.3 or broken='Y' and job not in (505,340,217,237,339,360,21);
exit;