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 vote339 views1 answer
Sql developer connect to sql server
SQL
0 vote349 views2 answers
Sql last updated
SQL
0 vote316 views1 answer
Sql server select ignore dupplicates
SQL
3 votes307 views4 answers
Show sql server database
SQL
1 vote318 views1 answer
Sql to mongodb query converter
SQL
10 votes332 views4 answers
Mysql one week ago
SQL
0 vote323 views1 answer
Install postgresql 12 on debian 10
SQL
0 vote326 views1 answer
Get only structure database mysql
SQL
0 vote353 views1 answer
What is server_default = func.now() in sqlalchemy
SQL
0 vote320 views1 answer
Components/Fields of Internal Table
SQL