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

2 votes167 views1 answer
SQLSTATE[HY000] [1049] Unknown database
SQL
0 vote344 views1 answer
How to connect .sql data set to powerbi
SQL
2 votes177 views1 answer
Columns Present in a table
SQL
1 vote167 views1 answer
Show all event schedular on mysql
SQL
0 vote184 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL
-1 vote187 views1 answer
Mysql order by on condition
SQL
0 vote176 views1 answer
Convert rows to columns in sql server
SQL
7 votes159 views1 answer
Oracle reset sequence
SQL
2 votes158 views1 answer
Plsql left() function
SQL
3 votes167 views1 answer
Sql multiple column index
SQL