dbms_job创建JOB简单实例

1.SQL> desc emp; 

  Name                                      Null?    Type 

  ----------------------------------------- -------- ---------------------------- 

  ID                                                 NUMBER 

  NAME                                               VARCHAR2(100) 
 SALARY                                             NUMBER

2.创建一存储过程
CREATE OR REPLACE PROCEDURE TEST IS
  BEGIN 
     for i in 1..10000000 loop
    INSERT INTO emp VALUES (1,'aa',2);
    end loop;
    COMMIT;
  END TEST;
3.创建一JOB
DECLARE
   V_JOB_NUMBER      NUMBER(10);
   V_INSTANCE_NUMBER NUMBER(10);
 BEGIN
   --SELECT V.INSTANCE_NUMBER INTO V_INSTANCE_NUMBER FROM V$INSTANCE V;
   DBMS_JOB.SUBMIT(V_JOB_NUMBER,
                   'aiki.TEST;',--不能省略后面的分号，最好添加上用户名
                   SYSDATE,
                   'SYSDATE +1/1440');
   COMMIT;
 END;4.完成