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.完成