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 vote419 views1 answer
Get substract count sql
SQL
0 vote357 views1 answer
How to move a column to different spot mysql
SQL
0 vote348 views1 answer
Sql select with apostrohpe
SQL
1 vote368 views1 answer
Sql dcl
SQL
0 vote384 views1 answer
000webhost database values insert
SQL
1 vote379 views1 answer
Customer using hdfc bank sql query
SQL
0 vote358 views1 answer
Get who is hired in february in sql
SQL
1 vote356 views1 answer
How to get mysql db size
SQL
1 vote362 views2 answers
Create table if not exist
SQL
4 votes353 views1 answer
Add constraint fk
SQL