oracle job 时间间隔,关于job的时间间隔的一个问题

奇怪的,第一次执行出问题!过一会又可以了...晕

SQL> exec statspack.snap;

PL/SQL 过程已成功完成。

SQL> @%oracle_home%\RDBMS\ADMIN\spauto.sql

begin

*

第 1 行出现错误:

ORA-23420: 间隔必须以将来的一个时间作评估

ORA-06512: 在 "SYS.DBMS_JOB", line 57

ORA-06512: 在 "SYS.DBMS_JOB", line 134

ORA-06512: 在 line 3

Job number for automated statistics collection for this instance

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Note that this job number is needed when modifying or removing

the job:

JOBNO

----------

Job queue process

~~~~~~~~~~~~~~~~~

Below is the current setting of the job_queue_processes init.ora

parameter - the value for this parameter must be greater

than 0 to use automatic statistics gathering:

NAME                                 TYPE

------------------------------------ ----------------------

VALUE

------------------------------

job_queue_processes                  integer

10

Next scheduled run

~~~~~~~~~~~~~~~~~~

The next scheduled run for this job is:

未选定行

SQL> @%oracle_home%\RDBMS\ADMIN\spauto.sql

PL/SQL 过程已成功完成。

Job number for automated statistics collection for this instance

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Note that this job number is needed when modifying or removing

the job:

JOBNO

----------

21

Job queue process

~~~~~~~~~~~~~~~~~

Below is the current setting of the job_queue_processes init.ora

parameter - the value for this parameter must be greater

than 0 to use automatic statistics gathering:

NAME                                 TYPE

------------------------------------ ----------------------

VALUE

------------------------------

job_queue_processes                  integer

10

Next scheduled run

~~~~~~~~~~~~~~~~~~

The next scheduled run for this job is:

JOB NEXT_DATE

---------- --------------

NEXT_SEC

----------------------------------------------------------------

21 08-1月 -08

12:00:00

SQL>