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 vote163 views1 answer
Sql_inner_join
SQL
0 vote162 views1 answer
Rails sql query converstion
SQL
0 vote150 views1 answer
Sql server concat null
SQL
0 vote155 views1 answer
How to populate a table in MySQL from and existing csv file
SQL
0 vote141 views1 answer
Change schema of all tables postgres
SQL
1 vote162 views1 answer
Load mysql dumb
SQL
0 vote169 views1 answer
Sql server sleep
SQL
2 votes185 views1 answer
Orcale index size
SQL
-1 vote148 views1 answer
Su: Authentication failure mysql
SQL
21 votes138 views1 answer
Cheatsheet for sql
SQL