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

2 votes270 views4 answers
List databases in sql server
SQL
0 vote201 views3 answers
Drop table operation failed on table 'TableHistory' because it is not supported operation on system-versioned temporal tables.
SQL
-2 votes212 views2 answers
Union all in sql
SQL
1 vote264 views1 answer
How to put value in variable mysql
SQL
0 vote210 views1 answer
Add SuperUser MySQL
SQL
9 votes248 views3 answers
Pyodbc connect to sql server
SQL
49 votes293 views6 answers
Get duplicate records in sql
SQL
0 vote210 views1 answer
Rename constraint postgresql
SQL
0 vote351 views1 answer
Hue hive UploadingTextFiletoHive
SQL
11 votes204 views2 answers
Having clause in sql
SQL