SQL 87
BC Disable failing jobs By allan on 28th September 2026 08:51:44 AM
  1. EXEC dbms_scheduler.stop_job(job_name => 'PROGRAM_140_52', force => TRUE);
  2. EXEC dbms_scheduler.stop_job(job_name => 'PROGRAM_139_53', force => TRUE);
  3.  
  4. BEGIN
  5.   dbms_scheduler.disable(name => 'PROGRAM_140_52', force => TRUE);
  6.   dbms_scheduler.disable(name => 'PROGRAM_139_53', force => TRUE);
  7.  
  8.   dbms_scheduler.stop_job(job_name => 'PROGRAM_140_52', force => TRUE);
  9.   dbms_scheduler.stop_job(job_name => 'PROGRAM_139_53', force => TRUE);
  10.  
  11. END;
  12.  
  13.  
  14. -- Disable MSSQL
  15.  
  16.  
  17. BEGIN
  18.   dbms_scheduler.drop_job(job_name => 'PROGRAM_61_4');
  19.   dbms_scheduler.drop_job(job_name => 'PROGRAM_753_144');
  20. END;
  21.  
  22.  
  23. -- Disable jobs OCI_ACD and OCI_ABD
  24.  
  25. BEGIN
  26.   dbms_scheduler.drop_job(job_name => 'PROGRAM_853_156');
  27.   dbms_scheduler.drop_job(job_name => 'PROGRAM_863_157');
  28.   dbms_scheduler.drop_job(job_name => 'PROGRAM_873_158');
  29.   dbms_scheduler.drop_job(job_name => 'PROGRAM_883_159');
  30. END;

Paste is for source code and general debugging text.

Login or Register to edit, delete and keep track of your pastes and more.

Raw Paste

Login or Register to edit or fork this paste. It's free.