Find out the JOB Broken:

Find out the JOB Broken:
========================

set lines 200
set pages 20
col interval format a15
col what format a80
col broken format a10
SELECT JOB,LAST_DATE,NEXT_DATE,INTERVAL,BROKEN,FAILURES,WHAT FROM DBA_JOBS WHERE BROKEN <> 'N' OR FAILURES <> 0;


privileg to manage scheduler jobs:
================================

grant manage scheduler to <username>;

Run job:
========
exec sys.dbms_ijob.run(20);

Stop Job:
======
exec sys.DBMS_SCHEDULER.STOP_JOB('BIODATA.BIO_CREATE_SA_MVS',TRUE);

disable scheduler :
==============

exec dbms_scheduler.disable('CMMMERCK.JOB_CMM_ERRORCHECK');

REMOVE JOB:
===========
exec sys.dbms_ijob.remove(251);

to unbreak:
===========
exec sys.DBMS_IJOB.BROKEN(5176,FALSE);

to break:
==========
exec sys.DBMS_IJOB.BROKEN(110,TRUE);