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 vote192 views1 answer
Como hacer un select entre fechas mysql
SQL
2 votes208 views2 answers
Storing timezones in postgres
SQL
0 vote183 views1 answer
Mysql group rows with same value
SQL
0 vote208 views1 answer
How to read the potentail error messages in ssis package
SQL
15 votes182 views2 answers
Sql order by multiple columns
SQL
26 votes191 views2 answers
Mysql workbench download
SQL
12 votes200 views2 answers
Delete all entries postgres
SQL
1 vote194 views1 answer
Mysql show table character set
SQL
0 vote204 views1 answer
Mysql update all record removing 2 hours from column
SQL
0 vote194 views1 answer
Cast float mysql
SQL