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

9 votes215 views4 answers
Oracle get table column names
SQL
5 votes174 views3 answers
Truncate function in sql oracle
SQL
2 votes169 views2 answers
Function in sql
SQL
0 vote179 views3 answers
Database restoring error
SQL
1 vote165 views1 answer
Sql server 2012 query history
SQL
2 votes172 views2 answers
Enable foreign key checks postgres
SQL
3 votes223 views1 answer
Sql several or
SQL
0 vote212 views1 answer
Postgres duplicate database in same server while other session is using source database
SQL
0 vote200 views1 answer
Plpgsql if statement
SQL
8 votes163 views3 answers
Postgresql connection string c#
SQL