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 vote187 views1 answer
Cahnge column name apex oracle
SQL
22 votes136 views3 answers
Join three tables sql
SQL
5 votes148 views3 answers
MySql get fields of table
SQL
0 vote144 views1 answer
Mysql not defined
SQL
2 votes138 views1 answer
Postgresql add entry to table
SQL
1 vote146 views3 answers
Remove unique key from a table
SQL
0 vote149 views1 answer
Sql delete dastabase
SQL
6 votes129 views4 answers
Mysql update set
SQL
0 vote134 views1 answer
Mysql connection with sqlalchecmy
SQL
20 votes151 views4 answers
Reset auto increment in MySQL
SQL