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 vote229 views1 answer
Search for replace in mysql
SQL
0 vote213 views1 answer
Get id if is not equal in certain table
SQL
2 votes233 views1 answer
Drop all foreign key constraints mysql
SQL
1 vote222 views1 answer
Mysql strict_trans_tables
SQL
0 vote245 views1 answer
Mysql Puede ser solamente un campo automatico y este debe ser definido como una clave
SQL
3 votes229 views3 answers
Mysql declare variable
SQL
0 vote219 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL
0 vote203 views1 answer
Mod function example
SQL
2 votes211 views2 answers
Sql strip non alphanumeric characters
SQL
0 vote232 views1 answer
Faire une recherche par liste de mot clé sql
SQL