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 vote246 views1 answer
Mysql a from on this page has
SQL
0 vote269 views1 answer
Eliminate zero from integer mysql
SQL
0 vote191 views1 answer
Mysql timeout 30 seconds
SQL
0 vote216 views1 answer
Oracle right characters
SQL
0 vote282 views2 answers
Insert data into multiple tables mysql
SQL
0 vote227 views1 answer
Compression of dabatase mysqldumo
SQL
2 votes220 views1 answer
Oracle table size
SQL
0 vote248 views1 answer
Mysql dump with table query
SQL
1 vote215 views1 answer
Import database from a file using mysql commandline
SQL
0 vote218 views1 answer
Mysql to get column name in database
SQL