job_remove_ndxsys.sql

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;