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 vote314 views1 answer
Sqlite update from another table
SQL
0 vote318 views1 answer
Postgres multiple left join causing duplicates jsonb_agg
SQL
0 vote350 views3 answers
Postgres trim string
SQL
0 vote295 views1 answer
Hex string sql becomes int64
SQL
0 vote310 views1 answer
Convert LDAP Epoch to Date
SQL
2 votes319 views1 answer
Q operator in plsql
SQL
0 vote303 views1 answer
Every Derived yable must have its own alias
SQL
1 vote322 views1 answer
Altrer name column postgres
SQL
1 vote281 views2 answers
Sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
SQL
0 vote304 views1 answer
Group by join columns per table
SQL