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 vote205 views1 answer
Mysql select month and year
SQL
0 vote246 views1 answer
Command line mysql xampp
SQL
0 vote228 views1 answer
Function plsql
SQL
0 vote218 views1 answer
Mysql command line ubuntu
SQL
0 vote227 views1 answer
Select even number id data from table
SQL
0 vote217 views2 answers
Mysql on update current_timestamp
SQL
-1 vote232 views1 answer
Auto increment psql not primary key
SQL
2 votes260 views1 answer
Tcl in sql
SQL
0 vote197 views1 answer
Resolved [java.sql.SQLException: ORA-29977: Unsupported column type for query registration in guaranteed mode ]
SQL
0 vote216 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL