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 vote136 views1 answer
Convert money to varchar sql server
SQL
0 vote169 views1 answer
Select from 3 tables one is empty
SQL
1 vote201 views2 answers
Mysql add column tinyint default 0
SQL
0 vote128 views1 answer
Flask_sqlalchemy install
SQL
17 votes218 views6 answers
Sql current date
SQL
2 votes169 views1 answer
No data found oracle
SQL
0 vote183 views1 answer
Create tables from xsd to sql server database c#
SQL
0 vote170 views1 answer
T sql check active deadlock
SQL
1 vote194 views1 answer
Ubuntu access database from terminal
SQL
5 votes159 views1 answer
List foreign key oracle
SQL