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 vote209 views1 answer
Mysql error codeigniter
SQL
0 vote225 views1 answer
Wordpress delete post revisions older than date "sql"
SQL
1 vote224 views1 answer
Mysql size int
SQL
0 vote234 views1 answer
Mysql date equals to current_date plus days
SQL
4 votes222 views2 answers
Bulk kill mysql processlist
SQL
1 vote225 views1 answer
Oracle drop chain step
SQL
7 votes222 views5 answers
Show details of table postgres
SQL
0 vote222 views1 answer
Createdb with postgresql on ubuntu
SQL
0 vote213 views1 answer
R dbConnect(odbc::odbc() to ms sql server remote
SQL
0 vote213 views1 answer
List column names of multiple tables psql
SQL