SQL 15
BC Disable failing jobs By allan on 14th November 2025 12:42:18 PM
  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. END;
  20.  
  21.  
  22. -- Disable jobs OCI_ACD and OCI_ABD
  23.  
  24. BEGIN
  25.   dbms_scheduler.drop_job(job_name => 'PROGRAM_853_156');
  26.   dbms_scheduler.drop_job(job_name => 'PROGRAM_863_157');
  27.   dbms_scheduler.drop_job(job_name => 'PROGRAM_873_158');
  28.   dbms_scheduler.drop_job(job_name => 'PROGRAM_883_159');
  29. 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.