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 vote373 views1 answer
Oracle calculate statistics on partition
SQL
0 vote298 views1 answer
No suitable driver found for sqlite
SQL
0 vote273 views1 answer
SQL server select to get sum of hours
SQL
0 vote322 views1 answer
SQL column name Oracle
SQL
2 votes333 views1 answer
Mysql id of inserted row
SQL
0 vote314 views1 answer
Adding primery key constraint to a column
SQL
4 votes286 views2 answers
How to delete row in sql
SQL
0 vote294 views1 answer
Debian 10 install postgresql 2ndquadrant
SQL
0 vote311 views1 answer
Mysql grouping functions
SQL
0 vote335 views1 answer
Create synonym for dblink in oracle
SQL