declare

  BEGIN
    --清空表数据，动态sql

    --删除原有的job
    FOR ITEM IN (SELECT a.job_name
  FROM Dba_Scheduler_Jobs         a,
       Dba_Scheduler_Running_Jobs b
 WHERE a.Job_Name = b.Job_Name
   AND a.Last_Run_Duration IS NULL
   and a.owner=b.owner 
                   --where owner='XMGL'/*WHERE JOB_NAME LIKE '%' || J_WHERE || '%'*/
                 ) LOOP
      BEGIN
        DBMS_SCHEDULER.stop_job(JOB_NAME => ITEM.JOB_NAME);
      EXCEPTION
        WHEN OTHERS THEN
   null;
      END;
    END LOOP;
  end;