Fix broken jobs
select ‘exec dbms_job.broken(job =>’||job||’, next_date=>’||interval||’, broken =>false)’ from dba_jobs where schema_user =’CIGMA_OP_FX’
and broken=’Y’
select ‘exec dbms_job.run(job =>’||job||’)’ from dba_jobs where schema_user =’CIGMA_OP_FX’ and broken=’Y';
exec dbms_job.broken(JOB=>&job_no, NEXT_DATE=>SYSDATE + &when_plus_sysdate, broken=>FALSE);