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 vote209 views7 answers
10 random questions use python and SQL
SQL
3 votes216 views3 answers
Mysql select table names
SQL
2 votes243 views1 answer
Revokeprivileges mysql
SQL
0 vote218 views2 answers
Unique key
SQL
3 votes199 views3 answers
Sql last week
SQL
0 vote204 views1 answer
QUERY JPQL
SQL
15 votes228 views5 answers
Select all tables sql
SQL
2 votes214 views3 answers
Sql interview query questions
SQL
0 vote203 views2 answers
Generate sql trigger through ef migration
SQL
0 vote198 views1 answer
Events not working db
SQL