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 vote273 views1 answer
Oracle date summer time
SQL
0 vote269 views1 answer
Mysql replication change database name
SQL
0 vote299 views1 answer
Oracle sql all days except weekends
SQL
0 vote328 views1 answer
Database disk image is malformed sqlite fix ubuntu
SQL
16 votes308 views6 answers
Mysql find duplicates in same table
SQL
3 votes305 views2 answers
See mysql users ubuntu
SQL
4 votes255 views2 answers
Oracle set date format
SQL
4 votes276 views2 answers
Postgresql reset sequence
SQL
15 votes274 views4 answers
T-sql drop function if exists
SQL
0 vote298 views1 answer
DATEDIFF minute postgres
SQL