create table HWQY.TEST(  CARNO     VARCHAR2(30),  CARINFOID NUMBER)

create or replace PRocedure pro_testAScarinfo_id number;BEGINselect s_CarInfoID.nextval into carinfo_id from dual;insert into test(test.carno,test.carinfoid) values(carinfo_id,'123');commit;end pro_test;

VARIABLE jobno number;beginDBMS_JOB.SUBMIT(:jobno, 'pro_test;',SYSDATE,'sysdate+1/24/12'); commit;end;/

英文代碼

SQL>  select job,next_date,next_sec,failures,broken from user_jobs;       JOB NEXT_DATE   NEXT_SEC           FAILURES BROKEN---------- ----------- ---------------- ---------- ------         1 2008-2-22 ?01:00:00                  0 N

begin dbms_job.remove(1);commit;end;/

PL/SQL procedure successfully completed

show parameter job_queue_processes;必須>0，否則執行下面的命令修改：alter system set job_queue_processes=5;

variable jobno number;begindbms_job.submit(:jobno, 'pro_test;',sysdate,'sysdate+1/24/12');commit; end; /

beginsys.dbms_job.submit(job => :jobno,what => 'pro_test;',next_date => to_date('21-02-2008 17:37:26', 'dd-mm-yyyy hh24:mi:ss'),interval => 'sysdate+1/24/12');commit;end;/所以，創建一個任務的完整的格式是：variable jobno number;beginsys.dbms_job.submit(job => :jobno,what => 'pro_test;',next_date => to_date('21-02-2008 17:37:26', 'dd-mm-yyyy hh24:mi:ss'),interval => 'sysdate+1/24/12');commit;end;/--系統會自動分配一個任務號jobno。

JOB NEXT_DATE NEXT_SEC FAILURES BROKEN1 1 2008-2-22 AM 01:00:00 01:00:00 0 N2 2 2008-2-21 PM 05:42:45 17:42:45 0 N3 3 2008-2-21 PM 05:42:45 17:42:45 0 N