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 vote362 views1 answer
Delete * from where id = 1;
SQL
23 votes363 views4 answers
Uninstall postgresql ubuntu
SQL
150 votes626 views10 answers
Grepper
SQL
3 votes357 views3 answers
Create table in microsoft sql server
SQL
8 votes346 views4 answers
Mysql update one table from another table multiple columns
SQL
10 votes370 views2 answers
SQL rounding numbers
SQL
1 vote347 views1 answer
How to get mysql db size
SQL
0 vote371 views1 answer
Top 3 salary in sql
SQL
2 votes345 views1 answer
Sql count having
SQL
0 vote289 views1 answer
Mysql collation for all languages
SQL