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

2 votes169 views1 answer
Date conversion in mysql column
SQL
0 vote188 views1 answer
Sql use with to get value counts and percentages
SQL
2 votes165 views2 answers
Mysql limit
SQL
3 votes191 views1 answer
Sql calculate working days between two dates excluding weekends and holidays
SQL
-1 vote179 views1 answer
Search all sql tables for a value
SQL
0 vote172 views1 answer
See Foreign Key
SQL
0 vote174 views1 answer
Get time component of datetime sql
SQL
0 vote175 views2 answers
What is the default password for sql server sa
SQL
9 votes156 views3 answers
Sequence postgresql
SQL
2 votes141 views2 answers
Mysql get last character of string
SQL