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

0 vote181 views1 answer
Openquery insert into linked server
SQL
2 votes200 views1 answer
Drop all foreign key constraints mysql
SQL
19 votes176 views2 answers
Mysql add column after another
SQL
4 votes207 views2 answers
Dbms output
SQL
0 vote166 views2 answers
How to set global time_zone in mysql
SQL
0 vote177 views1 answer
MQL4 mql4 run ea on all symbols by adding to just one chart
SQL
11 votes170 views1 answer
Oracle insert into where
SQL
2 votes186 views2 answers
Mysql limit
SQL
0 vote225 views1 answer
Oracle sql date winter time
SQL
7 votes175 views6 answers
Nth highest salary in sql
SQL