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 vote273 views1 answer
Mysql count multiple columns in one query
SQL
1 vote309 views1 answer
Sql server if exists update else insert
SQL
4 votes268 views2 answers
Sql vs mysql
SQL
0 vote348 views1 answer
Selecting specific day in colum sql
SQL
0 vote275 views1 answer
Min mysql
SQL
0 vote260 views1 answer
Oracle right characters
SQL
0 vote250 views1 answer
Sqlite3 not commit
SQL
0 vote280 views1 answer
Commit transaction sql
SQL
5 votes278 views2 answers
Get columns number sql
SQL
0 vote272 views1 answer
Psql not found windows
SQL