job数组

郑全

declare
   newjob sys.job;
   newjobarr sys.job_array;
begin
   newjobarr:=sys.job_array();
   newjobarr.extend(100);
   for i in 1..100 loop
       newjob:=sys.job(job_name=>'LWTJK' || TO_char(i),
                        job_style=>'LIGHTWEIGHT',
                        job_template=>'SYS.PROG_INSERT',
                        enabled=>true);
       newjobarr(i):=newjob;
   end loop;
   dbms_scheduler.create_jobs(newjobarr,'TRANSACTIONAL');
end;