BEGIN
   FOR C_JOBS IN (SELECT JOB
                    FROM USER_JOBS
                   WHERE WHAT LIKE '%ETL_DRO%') LOOP
       DBMS_JOB.REMOVE(C_JOBS.JOB);
   END LOOP;
   COMMIT;
END;
/

BEGIN
   FOR C_JOBS IN (SELECT JOB
                    FROM USER_JOBS
                   WHERE WHAT LIKE '%JOB_APURA_AJUSTECONS%') LOOP
       DBMS_JOB.REMOVE(C_JOBS.JOB);
   END LOOP;
   COMMIT;
END;
/