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

1 vote116 views1 answer
Mysql column start with string
SQL
0 vote100 views1 answer
Mysql function variable
SQL
0 vote88 views2 answers
Influxdb delete measurement based on date
SQL
0 vote128 views1 answer
Sqlalchemy _in array sqlite
SQL
1 vote513 views1 answer
How to lock table in mysql
SQL
0 vote267 views1 answer
Current month transactions in mysql
SQL
27 votes122 views6 answers
Sql update record
SQL
2 votes108 views1 answer
Sql ignore accents
SQL
0 vote103 views1 answer
Oracle sql log to console
SQL
2 votes101 views1 answer
Match in sql server
SQL