进入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
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