oracle drop job if exists

Solutions on MaxInterview for oracle drop job if exists by the best coders in the world

Search
showing results for - "oracle drop job if exists"
Garrett
10 Sep 2018
1DECLARE
2    l_job_exists NUMBER;
3BEGIN
4    SELECT count(*) INTO l_job_exists FROM ALL_SCHEDULER_JOBS
5    WHERE JOB_NAME = 'job_name' AND OWNER = 'owner_name';
6    IF l_job_exists = 1 THEN
7        dbms_scheduler.drop_job(job_name => 'STATISTICS_COLUMNS_JOB');
8    END IF;
9END;
source
similar questions
pl sql drop triggeroracle drop programdrop all triggers oracleoracle drop rulesoracle drop sequence if existsoracle drop joboracle drop sequence check if table exists oracleoracle list scheduled jobsoracle create program if not existssql drop view if existsoracle drop constrainthow to check all scheduled jobs in oracleoracle drop type if existsoracle create program if no existsoracle create job if not existsoracle enable joboracle stop jobdrop table if exists oracleoracle sql drop sequenceoracle drop index if existsjob oracle exempleoracle job schedulesoracle drop useroracle kill job by sidoracle sql drop column if existsoracle disable job
queries leading to this page
oracle delete jobhow to drop oracle jobsoracle drop job if existsoracle drop joboracle drop job if exists