Oracle drop job if 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_name';
    IF l_job_exists = 1 THEN
        dbms_scheduler.drop_job(job_name => 'owner_name.Job_name');
    END IF;
END;

Source: stackoverflow.com

Similar codes

2 votes351 views3 answers
Install mysql workbench ubuntu 20.04 terminal
SQL
1 vote367 views1 answer
Floor function in sql oracle
SQL
4 votes293 views1 answer
Mac install mysql
SQL
0 vote299 views1 answer
Downgrading sql localdb visual studio
SQL
0 vote304 views1 answer
Alter session set nls_language french
SQL
0 vote340 views1 answer
Mysql get date diff in months
SQL
0 vote361 views1 answer
Sqlalchemy _in array sqlite
SQL
0 vote329 views1 answer
How to connect pgadmin with excel
SQL
0 vote347 views2 answers
Sql day from datetime
SQL
12 votes324 views1 answer
Psql drop column
SQL