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

8 votes141 views1 answer
Ltrim sql
SQL
5 votes140 views1 answer
Oracle find foreign key dependencies
SQL
1 vote147 views1 answer
Oracle update with sequence
SQL
0 vote168 views1 answer
Sql get table last modified time
SQL
1 vote132 views1 answer
Can not connect to mysql server
SQL
2 votes192 views3 answers
Postgres create view
SQL
20 votes137 views5 answers
Sql show tables
SQL
0 vote135 views2 answers
Mysql set foreign_key_checks=0
SQL
0 vote136 views3 answers
Postgres trim string
SQL
1 vote143 views1 answer
Postgresql reset serial counter after deleting content
SQL