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 vote138 views1 answer
Sql query use select name inside where clause
SQL
8 votes166 views2 answers
Default sql server port
SQL
0 vote123 views4 answers
User defined function sql
SQL
0 vote133 views1 answer
Convert polygon to text in mysql
SQL
5 votes133 views1 answer
Commentaire table oracle
SQL
0 vote130 views1 answer
How to get specific salary in sql
SQL
8 votes160 views1 answer
Racle create auto increment column
SQL
0 vote116 views1 answer
Sqldf change user
SQL
2 votes147 views1 answer
Oracle kill session by sql_id
SQL
8 votes119 views5 answers
Grant permission in postgres
SQL