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

-1 vote124 views2 answers
Installing mysql on centos 7
SQL
0 vote111 views1 answer
Events not working db
SQL
4 votes118 views1 answer
Phone number sql
SQL
0 vote106 views1 answer
Kotlin sqlite delete row
SQL
0 vote121 views1 answer
How to generate ids in sql
SQL
0 vote115 views1 answer
Hibernate dialect property xml for mysql 8
SQL
2 votes127 views3 answers
Sql delete duplicate
SQL
0 vote122 views1 answer
Prodection ready postgres database step by step
SQL
8 votes111 views1 answer
Ltrim sql
SQL
0 vote117 views1 answer
Sort by last two number sql
SQL