Oracle stats, update row data only?

[Yogeeraj_1]

hi,

Answers to your questions:

>does it run 20 minutes after midnight tomorrow?
Yes.
SQL>alter session set nls_date_format='dd/mm/yyyy hh24:mi';

Session altered.

SQL>select trunc(sysdate+1)+((00+(20/60))/24) from dual;

TRUNC(SYSDATE+1)
________________
04/10/2007 00:20

SQL>


> the "interval" parameter is 20 minutes, does it rerun in 20 minutes?

interval => 'trunc(sysdate+1)+((00+(20/60))/24)'

This always evaluates to the next day at 00:20.

You may wish to make appropriate modifications.


hope this helps!
kind regards
yogeeraj

[TwoProc]

Thanks once again Yogeeraj.