Oracle JOB

首先我们创建一张表t_job_test:

 

CREATE TABLE t_job_test(
   f_name varchar2(20),
   f_date date
);

 创建存储过程my_procedure：

 

 

CREATE OR REPLACE PROCEDURE my_procedure 
AS
BEGIN
FOR i IN 1..10 
LOOP
INSERT INTO t_job_test VALUES('Nicky'||i,sysdate);
END LOOP;
COMMIT;
END;

 创建JOB:

DECLARE 
v_job number;
begin
dbms_job.submit(v_job,'my_procedure;',sysdate,'sysdate+1/1440');
commit;
end;
/

 运行job:

-- Run the job , 21 is the job id which select from dba_jobs
BEGIN
DBMS_JOB.RUN(21);
END;
/

 这样一个简单的job就完成了。