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 vote377 views2 answers
Temp tables in sql server
SQL
8 votes378 views1 answer
Oracle search stored procedures for text
SQL
0 vote376 views1 answer
Oracle current date minus 1 day
SQL
2 votes316 views2 answers
Function in sql
SQL
1 vote401 views2 answers
Drop table with constraints
SQL
1 vote359 views1 answer
Date in where on datetime column clause mysql
SQL
6 votes355 views3 answers
POSTGRES INSERT INTO TABLE VALUE FROM OTHER TABLE
SQL
3 votes404 views1 answer
Where id is in list sql
SQL
0 vote333 views1 answer
Mysql select last 15 minutes
SQL
0 vote490 views1 answer
Sql insert exemplo
SQL