SQL> --Schedule a snapshot to be run on this instance every hour, on the hour
SQL>
SQL> variable jobno number;
SQL> variable instno number;
SQL> begin
2select instance_number into :instno from v$instance;
3dbms_job.submit(:jobno, 'statspack.snap;', trunc(sysdate+1/1440,'HH'), 'trunc(SYSDATE+1/1440,''HH'')', TRUE, :ins
tno);
4commit;
5end;
6/
begin
*
ERROR at line 1:
ORA-23420: interval must evaluate to a time in the future
ORA-06512: at "SYS.DBMS_JOB", line 57
ORA-06512: at "SYS.DBMS_JOB", line 129
ORA-06512: at line 3
从网上找到出错的解析，但不太明白，能否解一下？
The program does not raise any packaged exceptions. The interval date expression must evaluate to a future date or the following Oracle exception will be raised:
Cause: The parameter INTERVAL evaluates to a time earlier than SYSDATE.
Action: Choose an expression that evaluates to a time later than SYSDATE
没看懂应怎么解决
|
