oracle create job

进入command窗口，执行以下语句即可：
SQL>  variable job1 number;
SQL>  begin
  2    dbms_job.submit(:job1,'w_proc_gendeviceinfo;',sysdate,'sysdate+1');
  3   end;
  4  /
 
PL/SQL procedure successfully completed
job1
---------
1143