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

1 vote271 views2 answers
Test sqlsrv connection
SQL
0 vote254 views1 answer
Renommer schema sql
SQL
1 vote277 views1 answer
Search for replace in mysql
SQL
0 vote264 views1 answer
Sql show all users
SQL
0 vote326 views2 answers
Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. Your result cannot contain duplicates.
SQL
1 vote251 views1 answer
Not exists mysql
SQL
0 vote264 views1 answer
Connexion mysql
SQL
0 vote260 views1 answer
Sql select merge multiple values
SQL
4 votes243 views2 answers
Oracle set date format
SQL
11 votes251 views2 answers
Having clause
SQL