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 vote273 views1 answer
Sqlalchemy get ids
SQL
14 votes304 views4 answers
Sql compiler
SQL
0 vote270 views2 answers
Sql drop view if exists
SQL
0 vote294 views1 answer
Insert into Select * - NAYCode.com
SQL
1 vote251 views1 answer
Mysql order by desc null last
SQL
1 vote277 views1 answer
Backup mysql data only
SQL
0 vote274 views1 answer
Mysql import datetime YYYY-MM-DDThh:mm:ss.000000Z
SQL
0 vote262 views1 answer
Mysqlimport
SQL
0 vote264 views1 answer
Mysql update privileges
SQL
16 votes269 views2 answers
Oracle ddl
SQL