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 vote321 views1 answer
Mysql search multiple tables
SQL
0 vote352 views1 answer
Sql query to get contact form 7 fields
SQL
1 vote332 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL
3 votes322 views3 answers
Remove all spaces from string sql
SQL
2 votes337 views1 answer
How to delete columns in sql
SQL
0 vote334 views1 answer
Sql last time database was accessed
SQL
0 vote314 views1 answer
Price-colour
SQL
7 votes301 views4 answers
How to reset the identity column in sql server
SQL
1 vote332 views4 answers
Aggregate function in sql
SQL
4 votes334 views4 answers
Rollback in sql
SQL