job任务执行了一次，然后就再也不执行了，这是为什么呢？

Question

1，我在查询user_jobs中job的所有信息如下：SQL> select * from user_jobs where job='87';       JOB LOG_USER                       PRIV_USER                      SCHEMA_USER                    LAST_DATE   LAST_SEC         THIS_DATE   THIS_SEC         NEXT_DATE   NEXT_SEC         TOTAL_TIME BROKEN INTERVAL                                                                           FAILURES WHAT                                                                             NLS_ENV                                                                          MISC_ENV                                                           INSTANCE
---------- ------------------------------ ------------------------------ ------------------------------ ----------- ---------------- ----------- ---------------- ----------- ---------------- ---------- ------ -------------------------------------------------------------------------------- ---------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ---------------------------------------------------------------- ----------
        87 FAQ                            FAQ                            FAQ                            2009-06-18  08:34:25                                      2009-06-19  01:38:26                  5 N      to_date('2009-06-16 00:00:00','yyyy-mm-dd hh24:mi:ss') + 1                               10 update t_repository  set status='0',update_time=sysdate where ceil(valid_time-sy NLS_LANGUAGE='SIMPLIFIED CHINESE' NLS_TERRITORY='CHINA' NLS_CURRENCY='￥' NLS_IS 0102000200000000                                                          0SQL> 

Answer 1

SQL> select * from user_jobs where job='87';       JOB LOG_USER                       PRIV_USER                      SCHEMA_USER                    LAST_DATE   LAST_SEC         THIS_DATE   THIS_SEC         NEXT_DATE   NEXT_SEC         TOTAL_TIME BROKEN INTERVAL                                                                           FAILURES WHAT                                                                             NLS_ENV                                                                          MISC_ENV                                                           INSTANCE
---------- ------------------------------ ------------------------------ ------------------------------ ----------- ---------------- ----------- ---------------- ----------- ---------------- ---------- ------ -------------------------------------------------------------------------------- ---------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ---------------------------------------------------------------- ----------
        87 FAQ                            FAQ                            FAQ                            2009-06-18  08:34:25                                      2009-06-19  01:38:26                  5 N      to_date('2009-06-16 00:00:00','yyyy-mm-dd hh24:mi:ss') + 1                               10 update t_repository  set status='0',update_time=sysdate where ceil(valid_time-sy NLS_LANGUAGE='SIMPLIFIED CHINESE' NLS_TERRITORY='CHINA' NLS_CURRENCY='￥' NLS_IS 0102000200000000                                                          0SQL> 

Answer 2

2，下面是plsql里面的job详细截图：

Answer 3

3，这是job任务参数值，用system进去获取的。SQL> select * from v$parameter where name like '%job%';       NUM NAME                                                                                   TYPE VALUE                                                                            DISPLAY_VALUE                                                                    ISDEFAULT ISSES_MODIFIABLE ISSYS_MODIFIABLE ISINSTANCE_MODIFIABLE ISMODIFIED ISADJUSTED ISDEPRECATED DESCRIPTION                                                                      UPDATE_COMMENT                                                                         HASH
---------- -------------------------------------------------------------------------------- ---------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- --------- ---------------- ---------------- --------------------- ---------- ---------- ------------ -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ----------
       704 job_queue_processes                                                                       3 10                                                                               10                                                                               FALSE     FALSE            IMMEDIATE        TRUE                  FALSE      FALSE      FALSE        number of job queue slave processes                                                                                                                               1663833312SQL> 

Answer 4

可能时间间隔有问题...
测试一下
interval => 'sysdate+1/48'

Answer 5

job定义完成后，别忘记commit 

Answer 6

在plsql里面，有了job截图，估计已经强行commit了吧。

Answer 7

我还了interval，还是跟原来的一模一样啊，执行失败了，如何搞？

Answer 8

你这个JOB是手工执行的吧，按你的INTERVAL      
to_date('2009-06-16 00:00:00','yyyy-mm-dd hh24:mi:ss') + 1 
就应该是17日的0点执行，这样写法只会执行一次
另外执行语句应该 前后加begin和END                                                                     

Answer 9

interval中的 to_date('2009-06-16 00:00:00','yyyy-mm-dd hh24:mi:ss') + 1
有问题，应该把它改成：
 to_date(sysdate,'yyyy-mm-dd hh24:mi:ss') + 1
否则只会执行一次