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 vote347 views1 answer
Mysql multiple primary keys
SQL
0 vote325 views1 answer
Error-expression-select-list-not-group-by-nonaggregated-column/
SQL
0 vote352 views1 answer
Mysql match in serialized data
SQL
2 votes313 views2 answers
Oracle multiple insert
SQL
0 vote352 views1 answer
Oracle webcenter content search enginer
SQL
0 vote359 views1 answer
Vbscript connect mssql
SQL
0 vote344 views1 answer
How to define a save method in ruby for sql databases
SQL
0 vote360 views1 answer
What is server_default = func.now() in sqlalchemy
SQL
0 vote372 views1 answer
C# execute transact sql
SQL
0 vote335 views1 answer
Postgres reorder columns
SQL