- EXEC dbms_scheduler.stop_job(job_name => 'PROGRAM_140_52', force => TRUE);
- EXEC dbms_scheduler.stop_job(job_name => 'PROGRAM_139_53', force => TRUE);
- BEGIN
- dbms_scheduler.disable(name => 'PROGRAM_140_52', force => TRUE);
- dbms_scheduler.disable(name => 'PROGRAM_139_53', force => TRUE);
- dbms_scheduler.stop_job(job_name => 'PROGRAM_140_52', force => TRUE);
- dbms_scheduler.stop_job(job_name => 'PROGRAM_139_53', force => TRUE);
- END;
- -- Disable MSSQL
- BEGIN
- dbms_scheduler.drop_job(job_name => 'PROGRAM_61_4');
- END;
- -- Disable jobs OCI_ACD and OCI_ABD
- BEGIN
- dbms_scheduler.drop_job(job_name => 'PROGRAM_853_156');
- dbms_scheduler.drop_job(job_name => 'PROGRAM_863_157');
- dbms_scheduler.drop_job(job_name => 'PROGRAM_873_158');
- dbms_scheduler.drop_job(job_name => 'PROGRAM_883_159');
- END;
Recent Pastes