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 vote120 views2 answers
How to display top 50 rows?
SQL
0 vote128 views1 answer
Services.AddDbContext DataSource Sqlite
SQL
-1 vote135 views1 answer
How to change the auto increment in existing table mysql
SQL
0 vote135 views1 answer
How to connect to mysql in ef 6
SQL
6 votes133 views2 answers
Mysql first day of month
SQL
0 vote141 views1 answer
"/** MySQL database password */" ext:txt | ext:cfg | ext:env | ext:ini
SQL
0 vote130 views1 answer
Convert uniqueidentifier to varchar in sql
SQL
15 votes126 views1 answer
Mysql int range
SQL
0 vote82 views1 answer
Deleted table in sql trigger
SQL
0 vote130 views1 answer
C# get sql min date
SQL