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 vote248 views1 answer
How to alter length character varying postgres
SQL
3 votes242 views2 answers
MySQL query to get column names
SQL
0 vote233 views1 answer
Postgres enumerated type
SQL
1 vote258 views1 answer
Trim leading zeros in sql
SQL
0 vote229 views1 answer
Mysql select last 15 minutes
SQL
0 vote243 views1 answer
Exit psql
SQL
0 vote235 views1 answer
Which MySQL data type to use for storing boolean values
SQL
1 vote247 views1 answer
Wordpress change http to https phpmyadmin
SQL
1 vote238 views1 answer
Sql delete row with auto increment
SQL
3 votes274 views1 answer
Oracle undo tablespace schema
SQL