Question : oracle drop job
Answered by : vastemonde
BEGIN dbms_scheduler.drop_job(job_name => 'MY_OWNER.MY_JOB');
END;Source : | Last Update : Wed, 10 Feb 21
Question : oracle drop job
Answered by : vastemonde
DECLARE l_job_exists NUMBER;
BEGIN SELECT count(*) INTO l_job_exists FROM ALL_SCHEDULER_JOBS WHERE JOB_NAME = 'job_name' AND OWNER = 'owner_name'; IF l_job_exists = 1 THEN dbms_scheduler.drop_job(job_name => 'owner_name.Job_name'); END IF;
END;Source : https://stackoverflow.com/questions/20178030/dbms-scheduler-drop-job-only-if-exists/20179943 | Last Update : Mon, 06 Sep 21