Refresh Groups / Broken jobs

From Below Queries for getting Job related and refresh group related info.


SQL> select owner, name, type, refgroup, job, next_date, interval from dba_refresh_children;


SQL> select owner, name, type, refgroup, job, to_char(next_date, 'DD-MON-RRRR') next_date, interval, broken from dba_refresh_children  where refgroup = 11;

SQL> select owner, name, job, refgroup from dba_refresh_children where broken = 'Y'

SQL> select SID,JOB,FAILURES from dba_jobs_running;


Drop Jobs:-
logon as sysdba and use:

to drop all users jobs
execute dbms_ijob.DROP_USER_JOBS('myuser');


or to drop a specific job
execute dbms_ijob.remove(94);