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

1 vote200 views1 answer
MySQL AND Operator
SQL
0 vote199 views2 answers
Select columns from 2 tables with foreign key
SQL
3 votes316 views3 answers
Mysql get table size
SQL
0 vote212 views1 answer
Where in clause tsql
SQL
0 vote230 views1 answer
Download sql file of countries names
SQL
0 vote250 views1 answer
SQL Cut part string
SQL
0 vote208 views2 answers
Temp tables in sql server
SQL
0 vote252 views1 answer
Plsql check for string in numeric
SQL
2 votes203 views1 answer
Mysql last 7 days including today
SQL
0 vote205 views1 answer
How to use query in nosql
SQL