Line 3719: FOR rec IN (SELECT job from user_jobs WHERE upper(what) like v_job_name || '%' and upper(broken) = 'N')
3715: THEN
3716: v_job_name := 'MSD_DEM_SOP.LOAD_SERIES_DATA_BATCH';
3717: END IF;
3718: 3719: FOR rec IN (SELECT job from user_jobs WHERE upper(what) like v_job_name || '%' and upper(broken) = 'N') 3720: LOOP
3721: dbms_job.remove (rec.job);
3722: END LOOP;
3723: