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 vote331 views1 answer
Sql select with apostrohpe
SQL
0 vote357 views1 answer
Set Mamp mysql globally
SQL
0 vote335 views1 answer
Sql datediff month
SQL
0 vote322 views1 answer
Sql auto_increment syntax
SQL
4 votes335 views1 answer
Oracle table statistics last analyzed
SQL
1 vote390 views2 answers
Install sql server management studio ubuntu
SQL
9 votes357 views3 answers
Date format in sql
SQL
0 vote347 views1 answer
The report definition has an invalid target namespace 'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner'
SQL
8 votes398 views2 answers
Default sql server port
SQL
1 vote346 views3 answers
Union in sql
SQL