job的问题,请大家讨论.
SQL> create table aa(a number,b date);
Table created
SQL>
SQL> create or replace procedure pro
2 is
3 begin
4 insert into aa values(1,sysdate);
5 end;
6 /
Procedure created
QL> declare
2 jobno number;
3 begin
4 dbms_job.submit(jobno,'pro;',trunc(sysdate),'trunc(sysdate)+1/(24*60)');
5 commit;
6 end;
7 /
declare
jobno number;
begin
dbms_job.submit(jobno,'pro;',trunc(sysdate),'trunc(sysdate)+1/(24*60)');
commit;
end;
ORA-23420: 间隔必须以将来的一个时间作评估
ORA-06512: 在"SYS.DBMS_JOB", line 57
ORA-06512: 在"SYS.DBMS_JOB", line 129
ORA-06512: 在line 4
是否与init.ora参数问题呢,具体如下:
job_queue_processes = 4
job_queue_interval = 10
open_links = 4