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 vote231 views1 answer
Mysql update column default value CURRENT_TIMESTAMP error
SQL
2 votes216 views2 answers
Postgres trigger insert into another table
SQL
0 vote200 views1 answer
Sql get month and year from date
SQL
0 vote197 views2 answers
Which MySQL statement is used to delete data from a database
SQL
25 votes225 views1 answer
How to update an attribute in MySQL
SQL
0 vote202 views1 answer
Syntax for changing column size in mysql
SQL
0 vote230 views1 answer
Add new column in sql with foreign key
SQL
14 votes228 views4 answers
Sql compiler
SQL
0 vote197 views1 answer
Postgresql create table with boolean column
SQL
4 votes215 views2 answers
Oracle last day of month
SQL