SQL> create table aa(a number,b date);Table createdSQL>
SQL> create or replace procedure pro
2 is
3 begin
4 insert into aa values(1,sysdate);
5 end;
6 /Procedure createdQL> declare
2 jobno number;
3 begin
4 dbms_job.submit(jobno,'pro;',sysdate,'trunc(sysdate)+34/24');
5 commit;
6 end;
7 /
SQL> create or replace procedure pro
2 is
3 begin
4 insert into aa values(1,sysdate);
5 end;
6 /Procedure createdQL> declare
2 jobno number;
3 begin
4 dbms_job.submit(jobno,'pro;',sysdate,'trunc(sysdate)+34/24');
5 commit;
6 end;
7 /
使用JOB:
sql>variable job number;
sql> begin
DBMS_JOB.SUBMIT(:jobno,//job号
'your_procedure;',//要执行的过程名称
trunc(sysdate)+1/24,//下次执行时间
'trunc(sysdate)+1/24+1'//每次间隔时间
);
end;但记住看看在你的init文件中,有没有加上参数
JOB_QUEUE_PROCESSES
JOB_QUEUE_INTERVAL