Enable and Disable Scheduler from Backend

Enable and Disable Scheduler from Backend

BEGIN

dbms_scheduler.enable('GEO_TRANS_PF_JOB');

END

BEGIN

dbms_scheduler.disable('GEO_TAG_PF_JOB');

END;

Checking Error From Backend

Its sometime very painful to Look for Error from Control Center.

It is better to check error from backend.

Below are the script i used to check the same :-

select * from ALL_RT_AUDIT_PROC_RUN_ERRORS where updated_on >= '13-JUL-11 03:08:59 PM'

order by updated_on desc

select * from ALL_RT_AUDIT_MAP_RUN_ERRORS where updated_on >= '13-JUL-11 05:07:08 PM'

order by updated_on desc

select * from ALL_RT_AUDIT_MAP_RUN_ERRORS map_err , ALL_RT_AUDIT_MAP_RUNS Map_run

where map_err.map_run_id = Map_run.map_run_id

and map_err.updated_on >= '13-JUL-11 05:07:08 PM'

order by map_err.updated_on desc