job的定时执行问题
我按照网上的例子一步一步的执行:
SQL> create table test_job(time date);
Table created
SQL> create or replace procedure MYPROC as
2 begin
3 insert into test_job values(sysdate);
4 end;
5 /
Procedure created
SQL> variable job1 number;
SQL> begin
2 dbms_job.submit(:job1,'MYPROC;',sysdate,'sysdate+1/1440');
3 end;
4 /
PL/SQL procedure successfully completed
job1
---------
148
SQL> begin
2 dbms_job.run(:job1);
3 end;
4 /
PL/SQL procedure successfully completed
job1
---------
148
SQL> select to_char(time,'yyyy-mm-dd hh24:mi:ss') 时间 from test_job;
时间
---------------------------------------------------------------------------
2010-01-27 09:06:52
SQL> select to_char(time,'yyyy-mm-dd hh24:mi:ss') 时间 from test_job;
时间
---------------------------------------------------------------------------
2010-01-27 09:06:52
隔了好久之后还是一条???
查询:
SQL> SELECT JOB, NEXT_DATE, NEXT_SEC, FAILURES, BROKEN
2 FROM DBA_JOBS;
JOB NEXT_DATE NEXT_SEC FAILURES BROKEN
---------- ----------- ---------------- ---------- ------
501 2008-6-2 17 17:31:08 N
502 2008-6-2 17 17:32:04 N
503 2008-6-2 17 17:31:08 N
47 2008-6-15 1 10:50:29 N
48 2008-6-15 1 10:50:30 N
4 2008-6-26 1 16:11:31 N
5 2008-6-26 1 16:11:31 N
108 2008-11-28 08:41:06 4 N
127 2009-2-11 8 08:40:00 N
564 2008-8-7 14 14:47:51 N
565 2008-8-7 23 23:07:01 N
107 2008-11-30 01:00:00 3 N
148 2010-1-27 9 09:07:52 0 N
13 rows selected
SQL> SELECT SID, r.JOB, LOG_USER, r.THIS_DATE, r.THIS_SEC
2 FROM DBA_JOBS_RUNNING r, DBA_JOBS j
3 WHERE r.JOB = j.JOB;
SID JOB LOG_USER THIS_DATE THIS_SEC
---------- ---------- ------------------------------ ----------- ----------------
请大家帮忙看看??谢谢