Oracle drop job

BEGIN
  dbms_scheduler.drop_job(job_name => 'MY_OWNER.MY_JOB');
END;

Oracle drop job

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

2 votes273 views1 answer
Mysql list users on ubuntu
SQL
0 vote277 views1 answer
Stuff in sql server
SQL
0 vote338 views2 answers
Sql unique
SQL
0 vote295 views1 answer
Sql server express download
SQL
0 vote292 views1 answer
Sql change date format
SQL
15 votes290 views2 answers
Select Options
SQL
8 votes316 views2 answers
Phpmyadmin default password
SQL
2 votes310 views1 answer
Can you use a where clause for a child query
SQL
0 vote307 views1 answer
Oracle for loop on list
SQL
4 votes1.1K views1 answer
Oracle show errors
SQL