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 vote249 views1 answer
Psql search table
SQL
0 vote364 views1 answer
The package java.sql is not accessible
SQL
0 vote234 views1 answer
List all permissions on a table in postgres
SQL
-1 vote191 views1 answer
Search all database tables for a value sqlserver
SQL
0 vote202 views1 answer
Get primary key of table
SQL
0 vote200 views1 answer
Postgres multiple left join causing duplicates jsonb_agg
SQL
1 vote298 views1 answer
Sql server delete top 1000
SQL
2 votes276 views2 answers
Postgres timestamp to datetime
SQL
0 vote200 views1 answer
Bus source and destination equal to destination and source of another by sql query
SQL
0 vote237 views1 answer
"Hello User Name"
SQL