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 vote98 views1 answer
Tsql default value when no value returned by query
SQL
0 vote102 views1 answer
Update and keep original value sql
SQL
0 vote102 views2 answers
Plsql regex match whole word
SQL
2 votes113 views1 answer
How to Add a Default Value to a Column in MS SQL Server
SQL
2 votes106 views2 answers
Mysql add hours to time field
SQL
0 vote113 views1 answer
What is default mysql database password in linux
SQL
0 vote103 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL
2 votes98 views1 answer
Convert series number to date in sql
SQL
3 votes105 views2 answers
Sql add year to date
SQL
0 vote110 views1 answer
Mysql pv progres
SQL