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

9 votes228 views6 answers
Sql add column with default value
SQL
21 votes192 views7 answers
Table drop if exist sql server
SQL
0 vote204 views1 answer
Mysql update sum same table
SQL
0 vote184 views1 answer
Oracle function select into
SQL
3 votes233 views2 answers
Sql select data from last week
SQL
0 vote305 views1 answer
ORA-01400
SQL
0 vote232 views1 answer
Why we have to set the password for my sql server
SQL
2 votes214 views1 answer
Install sqlite npm
SQL
8 votes241 views3 answers
SQL column name
SQL
2 votes220 views2 answers
How to get capital letter first in sql
SQL