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 vote113 views3 answers
Coderbyte mysql challenge MySQL challenge, your query should return the informatioi for the employee with the third highest salary.
SQL
16 votes117 views6 answers
Install sqlite3 python
SQL
0 vote113 views1 answer
Why mysql is used?
SQL
0 vote124 views1 answer
Create boolean column in MySQL with false as default value?
SQL
6 votes130 views3 answers
Mysql create database utf8
SQL
1 vote150 views1 answer
Drop colum oracle 18c
SQL
4 votes126 views2 answers
Show all database inside postgresql
SQL
0 vote124 views1 answer
How to display value of variable in mysql
SQL
1 vote126 views1 answer
Sql view where tables have same column name combine results
SQL
0 vote121 views2 answers
Pop sql insert value into
SQL