SET serveroutput ON; SET linesize 100; SET echo ON; spool job_remove.LOG; SELECT JOB, SCHEMA_USER, BROKEN, WHAT FROM dba_jobs; EXECUTE DBMS_JOB.REMOVE(&job_number_to_remove) COMMIT; SELECT JOB, SCHEMA_USER, BROKEN, WHAT FROM dba_jobs; spool off;
Do you like this page? Then support it. Please click the AD below and visit the sponsor. Thank you!