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 vote165 views4 answers
Between vs in sql
SQL
0 vote203 views2 answers
MySQL PARTITION BY month automatically
SQL
2 votes240 views2 answers
Postgres set user as superuser
SQL
1 vote184 views1 answer
Sql select where id not exists in another table
SQL
0 vote175 views1 answer
T-sql update table variale
SQL
0 vote178 views1 answer
Mysql find non alphanumeric characters
SQL
1 vote172 views3 answers
Mariadb add foreign key
SQL
0 vote190 views1 answer
ValueError: A string literal cannot contain NUL (0x00) characters.
SQL
18 votes185 views6 answers
Drop table if exists
SQL
0 vote176 views1 answer
Set column in all row mysql
SQL