跑statspack的job报这个错误：*** SESSION ID:(150.26013) 2009-04-21 03:02:07.419
*** 2009-04-21 03:02:07.419
ORA-12012: error on auto execute of job 39380
ORA-12005: may not schedule automatic refresh for times in the past


[@more@]

跑statspack的job报这个错误：

*** SESSION ID:(150.26013) 2009-04-21 03:02:07.419
*** 2009-04-21 03:02:07.419
ORA-12012: error on auto execute of job 39380
ORA-12005: may not schedule automatic refresh for times in the past

发现了这个网页的说明：http://blog.163.com/ansel_zlh/blog/static/103727172008825113225901/

是因为next_date晚于当前时间造成的。

但是他认为job是成功执行了的。

我的statspack是按照eygle的文档装的，spauto.sql原来的定时间隔是trunc(SYSDATE+1/24,'HH')。我打算让它半个小时跑一次，结果改成了：trunc(SYSDATE+1/48,'HH')。

eygle的原文定时间隔是：trunc(SYSDATE+1/48,'MI')

时间间隔设成trunc(SYSDATE+1/48,'HH')的后果是该job在每个小时的前半个小时之内一直会尝试运行，并报错，这个可以通过警告日志看出规律：

-rw-r----- 1 oracle oinstall 683 Apr 22 14:14 transact_j000_16373.trc
-rw-r----- 1 oracle oinstall 683 Apr 22 14:06 transact_j003_15472.trc
-rw-r----- 1 oracle oinstall 875 Apr 22 14:02 transact_j003_14853.trc
-rw-r----- 1 oracle oinstall 682 Apr 22 13:14 transact_j003_10052.trc
-rw-r----- 1 oracle oinstall 678 Apr 22 13:06 transact_j000_814.trc
-rw-r----- 1 oracle oinstall 681 Apr 22 13:02 transact_j002_8954.trc
-rw-r----- 1 oracle oinstall 680 Apr 22 13:00 transact_j002_8596.trc
-rw-r----- 1 oracle oinstall 680 Apr 22 12:14 transact_j003_3920.trc
-rw-r----- 1 oracle oinstall 680 Apr 22 12:06 transact_j003_3018.trc
-rw-r----- 1 oracle oinstall 680 Apr 22 12:02 transact_j003_2690.trc
-rw-r----- 1 oracle oinstall 680 Apr 22 12:00 transact_j003_2338.trc
-rw-r----- 1 oracle oinstall 900 Apr 22 11:17 transact_j002_27896.trc
-rw-r----- 1 oracle oinstall 682 Apr 22 11:14 transact_j003_27488.trc
-rw-r----- 1 oracle oinstall 681 Apr 22 11:06 transact_j003_26784.trc
-rw-r----- 1 oracle oinstall 681 Apr 22 11:02 transact_j003_26322.trc
-rw-r----- 1 oracle oinstall 683 Apr 22 11:00 transact_j003_25932.trc
-rw-r----- 1 oracle oinstall 682 Apr 22 10:14 transact_j002_20916.trc
-rw-r----- 1 oracle oinstall 682 Apr 22 10:06 transact_j002_19881.trc
-rw-r----- 1 oracle oinstall 683 Apr 22 10:02 transact_j000_19351.trc
-rw-r----- 1 oracle oinstall 683 Apr 22 10:00 transact_j003_19025.trc
-rw-r----- 1 oracle oinstall 682 Apr 22 09:14 transact_j003_13697.trc
-rw-r----- 1 oracle oinstall 682 Apr 22 09:06 transact_j002_12830.trc
-rw-r----- 1 oracle oinstall 682 Apr 22 09:02 transact_j004_12399.trc
-rw-r----- 1 oracle oinstall 682 Apr 22 09:00 transact_j003_12142.trc
-rw-r----- 1 oracle oinstall 680 Apr 22 08:14 transact_j003_7391.trc
-rw-r----- 1 oracle oinstall 680 Apr 22 08:06 transact_j003_5183.trc
-rw-r----- 1 oracle oinstall 680 Apr 22 08:02 transact_j002_6088.trc

都是发生在每个小时的前半个小时。

至于错误发生时，该job运行了没有呢？这个可以通过spreport.sql脚本看出来：

2 20 Apr 2009 11:30 5
3 20 Apr 2009 12:30 5
4 20 Apr 2009 13:30 5
5 20 Apr 2009 14:30 5
6 20 Apr 2009 15:30 5
7 20 Apr 2009 16:30 5
8 20 Apr 2009 17:30 5
9 20 Apr 2009 18:30 5
10 20 Apr 2009 19:30 5
11 20 Apr 2009 20:30 5
12 20 Apr 2009 21:30 5
13 20 Apr 2009 22:30 5
14 20 Apr 2009 23:30 5
15 21 Apr 2009 00:30 5
16 21 Apr 2009 01:30 5
17 21 Apr 2009 02:30 5
18 21 Apr 2009 03:30 5
19 21 Apr 2009 04:30 5
20 21 Apr 2009 05:30 5
21 21 Apr 2009 06:30 5
22 21 Apr 2009 07:30 5
23 21 Apr 2009 08:30 5
24 21 Apr 2009 09:30 5
25 21 Apr 2009 10:30 5
26 21 Apr 2009 11:30 5
27 21 Apr 2009 12:30 5
28 21 Apr 2009 13:30 5
29 21 Apr 2009 14:30 5
30 21 Apr 2009 15:30 5
31 21 Apr 2009 16:30 5

32 21 Apr 2009 17:30 5
33 21 Apr 2009 18:30 5
34 21 Apr 2009 19:30 5
35 21 Apr 2009 20:30 5
36 21 Apr 2009 21:30 5
37 21 Apr 2009 22:30 5
38 21 Apr 2009 23:30 5
39 22 Apr 2009 00:30 5
40 22 Apr 2009 01:30 5
41 22 Apr 2009 02:30 5
42 22 Apr 2009 03:30 5
43 22 Apr 2009 04:30 5
44 22 Apr 2009 05:30 5
45 22 Apr 2009 06:30 5
46 22 Apr 2009 07:30 5
47 22 Apr 2009 08:30 5
48 22 Apr 2009 09:30 5
49 22 Apr 2009 10:30 5
50 22 Apr 2009 10:51 5
51 22 Apr 2009 11:30 5
52 22 Apr 2009 12:30 5
53 22 Apr 2009 13:30 5

凡是成功运行的，都是在运行在 xx:30 时刻。显然，凡是发生ORA-12005错误的时候，该job并没有成功运行。