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 vote139 views5 answers
Convert sql to linq query online
SQL
0 vote131 views1 answer
Error-expression-select-list-not-group-by-nonaggregated-column/
SQL
0 vote131 views1 answer
Sql row number in result set
SQL
2 votes128 views2 answers
Sql query to list all tables in a database sql server
SQL
2 votes152 views1 answer
Laravel sql String
SQL
0 vote221 views1 answer
Insensitive case match sqlalchemy
SQL
0 vote128 views1 answer
Implizite joins sql
SQL
2 votes122 views1 answer
How to add where command in update comand with joins
SQL
2 votes122 views1 answer
Oracle calculated column
SQL
-1 vote141 views1 answer
Capitole toulouse
SQL