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 vote353 views1 answer
Sql anywhere create procedure
SQL
0 vote352 views1 answer
Drop all tables db2
SQL
1 vote350 views1 answer
Psql connect to another database
SQL
0 vote396 views2 answers
Get item by composite primary key mysql
SQL
0 vote353 views1 answer
Postgres full text search example
SQL
0 vote370 views1 answer
Mysql subtract month from timestamp
SQL
0 vote423 views1 answer
Mysql delete entire row on condition
SQL
0 vote356 views1 answer
Number(10 2) in sql means
SQL
0 vote370 views1 answer
Sql convert datetime to year
SQL
0 vote357 views1 answer
Mysql select where field like in list
SQL