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

0 vote146 views1 answer
Oracle decode
SQL
0 vote85 views1 answer
Sql query with date
SQL
0 vote150 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
0 vote134 views1 answer
Mysql cli output to a file
SQL
0 vote171 views1 answer
Mysql failed to login as root@localhost
SQL
0 vote136 views1 answer
Dapper run sql script with parameters
SQL
0 vote121 views1 answer
The local psql command could not be located
SQL
0 vote183 views1 answer
Mysql grant access to one database
SQL
46 votes202 views4 answers
Create column sql
SQL
2 votes132 views1 answer
Q operator in oracle
SQL