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 vote338 views1 answer
Sub blocks in sql
SQL
0 vote363 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL
0 vote378 views2 answers
Default constraint in ms sql
SQL
0 vote347 views1 answer
SQL add a totals of differemt rows of the same id
SQL
0 vote348 views1 answer
Mysql two joins
SQL
2 votes325 views1 answer
Plsql left() function
SQL
8 votes354 views3 answers
Oracle auto_increment
SQL
0 vote338 views1 answer
Mysql show foreign keys column
SQL
9 votes363 views2 answers
Sql limit to 5 results
SQL
-1 vote342 views1 answer
Mysql #1064 error
SQL