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 vote200 views1 answer
How to use mysql_tzinfo_to_sql on windows
SQL
5 votes159 views2 answers
To date oracle
SQL
0 vote185 views1 answer
Openquery update linked server
SQL
6 votes158 views4 answers
Remove spaces sql server
SQL
0 vote143 views1 answer
Oracle query archive mode
SQL
0 vote149 views1 answer
Google sheets filter rows above current cell
SQL
0 vote160 views1 answer
Sql values not in another table
SQL
5 votes203 views2 answers
Add days in oracle sql
SQL
0 vote149 views2 answers
Sql server select where date
SQL
3 votes156 views1 answer
Sql is not like
SQL