Oracle create job if not 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';
    IF l_job_exists = 1 THEN
        dbms_scheduler.drop_job(job_name => 'job_name');
    END IF;
END;
/
BEGIN DBMS_SCHEDULER.CREATE_JOB(job_name => '"owner"."job_name"', ...); END;

Similar codes

0 vote162 views1 answer
Setval in postgres
SQL
0 vote309 views1 answer
Multiple row join
SQL
14 votes161 views2 answers
Install mysqldump
SQL
3 votes154 views2 answers
Plsql print
SQL
19 votes192 views4 answers
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
SQL
0 vote148 views1 answer
How to reset table in sql server
SQL
0 vote163 views1 answer
Sql combine results from two tables
SQL
1 vote160 views1 answer
How to select rows with no matching entry in another table?
SQL
60 votes455 views6 answers
Add column in sql
SQL
8 votes149 views1 answer
Today minus 15 days postgresql
SQL