Oracle drop job if exists

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: stackoverflow.com

Similar codes

0 vote215 views1 answer
Oracle winter time change
SQL
0 vote222 views1 answer
Sql query inline if
SQL
19 votes191 views2 answers
Mysql add column after another
SQL
6 votes187 views2 answers
Drop foreign key
SQL
17 votes195 views6 answers
Mysql import sql file
SQL
0 vote213 views1 answer
How to remove quotes from a string in ssis load file
SQL
10 votes218 views2 answers
Select nextval from sequence oracle
SQL
6 votes186 views3 answers
Mysql server is not starting xampp
SQL
0 vote199 views1 answer
How to to get time in sql
SQL
15 votes205 views5 answers
If null mysql
SQL