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

3 votes273 views3 answers
Start postgresql ubuntu
SQL
0 vote267 views1 answer
Mysql select field if condition
SQL
7 votes268 views6 answers
Group_concat in mysql
SQL
0 vote277 views1 answer
Sql script get all stored procedures from database
SQL
1 vote264 views1 answer
Oracle grant on all tables in schema
SQL
1 vote250 views1 answer
Postgres format date in select
SQL
0 vote284 views1 answer
Sql select column name like from multiple tables
SQL
0 vote278 views1 answer
Shortcut run sql pgadmin
SQL
6 votes246 views1 answer
Rank function in oracle with example
SQL
3 votes245 views1 answer
Sql several or
SQL