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 vote201 views1 answer
See the structure of a table mysql
SQL
0 vote181 views2 answers
Mysql to python pandas
SQL
7 votes174 views3 answers
How to check table name in current database sql
SQL
10 votes192 views2 answers
Doublon sql
SQL
-1 vote153 views1 answer
MySQL said: Documentation #1010 - Error dropping database errno: 39 "Directory not empty")
SQL
0 vote205 views2 answers
.... ERROR! The server quit without updating PID file mysql centos
SQL
22 votes194 views3 answers
Year format in date mysql
SQL
2 votes170 views1 answer
Convert series number to date in sql
SQL
1 vote180 views1 answer
Access the postgres psql
SQL
2 votes178 views1 answer
Query to find table size in oracle 12c
SQL