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 vote195 views1 answer
Sql server for loop
SQL
0 vote299 views1 answer
How to get table current identity value in sql server
SQL
1 vote208 views1 answer
Oracle compile schema
SQL
5 votes201 views1 answer
Oracle list days between two dates
SQL
3 votes181 views1 answer
Oracle list dates without weekends
SQL
5 votes192 views2 answers
Oracle find all tables with column name
SQL
0 vote193 views2 answers
How to delete the rows with null values in mysql
SQL
0 vote174 views1 answer
Select value from previous row in postgresql
SQL
2 votes130 views1 answer
Sql view column data type
SQL
0 vote207 views1 answer
Datagrip execute procedure
SQL