ORACLE 9, WINDOWS,JOB任务问题.
wyjam 2006-10-25 02:22:25 select * from v$version;
Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
PL/SQL Release 9.0.1.1.1 - Production
CORE 9.0.1.1.1 Production
TNS for 32-bit Windows: Version 9.0.1.1.0 - Production
NLSRTL Version 9.0.1.1.1 - Production
//创建过程
create or replace procedure sp_insert_epuserlog
as
v_oid number;
begin
select userlog_s.nextval into v_oid from dual;
insert into userlog(oid,logname,datetime) values(v_oid,'abcdefg',sysdate);
commit;
end;
//添加任务 每两分钟执行一次
SQL> variable job1 number;
SQL> begin
2 dbms_job.submit(:job1,'sp_insert_epuserlog;', sysdate,'sysdate+1/720');
3 end;
4 /
SQL> select job,next_date,next_sec,failures,broken from user_jobs;
JOB NEXT_DATE NEXT_SEC FAILURES BROKEN
---------- ----------- ---------------- ---------- ------
6 2006-10-24 11:36:36 N
SQL> begin
2 dbms_job.run(6);
3 end;
4 /
手工测试都正常, 可就是没办法自动去执行这个任务.
后来看到有文章说计时器溢出什么的.但我想不应该是这个问题.
就按
alter system set job_queue_processes=0;-->
alter system set job_queue_processes=5;
重启数据库.
就可以执行任务了.
可是下班关机,第二天又不行了.
faint~... ...
http://www.aspx.cn/html/database/oracle/602/41978.html中有提到计时器溢出对应的解决方案.