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

22 votes172 views3 answers
Sql cheat sheet
SQL
0 vote180 views1 answer
Mysql equivalent decode oracle
SQL
0 vote164 views1 answer
Original Query
SQL
0 vote151 views1 answer
Sql query to force the database to be drop
SQL
0 vote171 views1 answer
Mysqldump: error:
SQL
2 votes150 views1 answer
Sqlite indexes
SQL
0 vote142 views1 answer
How to export table data from mysql table in sql format
SQL
1 vote163 views1 answer
How to see which columns are indexxed mysql
SQL
0 vote162 views1 answer
Query for backup a database at another location in file system
SQL
0 vote144 views1 answer
Sql last 7 days
SQL