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

1 vote132 views1 answer
Oracle drop job if exists
SQL
5 votes109 views1 answer
Mysql get last day of month
SQL
0 vote109 views1 answer
Vbscript create ADODB.Connection
SQL
3 votes112 views1 answer
Show index table
SQL
0 vote116 views1 answer
Sql get guid
SQL
0 vote108 views1 answer
Java spring boot connect to sql server
SQL
0 vote112 views1 answer
Oracle gather table statistics
SQL
0 vote129 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL
0 vote126 views2 answers
How to drop mili second in sql
SQL
2 votes123 views2 answers
Microsoft sql server extract hour and minute from datetime
SQL