How to drop a job?
834783Nov 1 2011 — edited Nov 4 2011I am using 8.1.7.4
These commands do not remove the job 61...
SELECT * FROM dba_jobs_running;
SELECT JOB FROM DBA_JOBS WHERE JOB=61;
BEGIN
EXECUTE DBMS_JOB.REMOVE(61);
COMMIT;
END;
SELECT JOB FROM DBA_JOBS WHERE JOB=61;