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

4 votes184 views3 answers
Count with where
SQL
3 votes188 views2 answers
See mysql users ubuntu
SQL
12 votes176 views1 answer
Docker mysql random root password
SQL
0 vote719 views1 answer
Sql show table name in result
SQL
0 vote163 views1 answer
Distinct data types in a table sql query
SQL
2 votes226 views1 answer
Mysql now format
SQL
8 votes219 views1 answer
Mac restore mysql database command line
SQL
11 votes161 views2 answers
Insert date sql
SQL
0 vote178 views1 answer
Look at running processes redshift
SQL
25 votes167 views1 answer
Mysql grant all privileges to a user
SQL