begin
  for cur in (
    select job_id, data_locator
    from dev1_biplatform.xmlp_sched_job@bi
    where user_job_name in ('имя') )
  loop
  
    for cur_out in (
      select output_id
      from dev1_biplatform.xmlp_sched_output@bi
      where job_id = cur.job_id )
    loop
      delete from dev1_biplatform.xmlp_sched_delivery@bi
      where output_id = cur_out.output_id;
    end loop;
    
    delete from dev1_biplatform.xmlp_sched_output@bi
    where job_id = cur.job_id;
    
    delete from dev1_biplatform.xmlp_sched_data@bi 
    where data_id = cur.data_locator 
      and cur.data_locator is not null;
      
    delete from dev1_biplatform.qrtz_cron_triggers@bi 
    where trigger_name = cur.job_id;
    
    delete from dev1_biplatform.qrtz_fired_triggers@bi 
    where trigger_name = cur.job_id;

    delete from dev1_biplatform.qrtz_blob_triggers@bi 
    where trigger_name = cur.job_id;

    delete from dev1_biplatform.qrtz_simple_triggers@bi 
    where trigger_name = cur.job_id;
    
    delete from dev1_biplatform.qrtz_triggers@bi 
    where trigger_name = cur.job_id;
    
    delete from dev1_biplatform.qrtz_job_details@bi 
    where job_name = cur.job_id;
    
    delete from dev1_biplatform.xmlp_sched_job@bi
    where job_id = cur.job_id;
    
  end loop;
  commit;
end;
/