If you are not already aware there is an spauto.sql in the $ORACLE_HOME/rdbms/admin directory which could be modified with the following
for example:
next_date=>trunc(sysdate)+10/24, interval=>'trunc(sysdate)+10/24');
Regards
Murali
Zabair Ahmed <[EMAIL PROTECTED]> wrote:
Quick question, I want to submit statspack.snap at 10:00am and 14:00pm through dbms_job, it's friday afternoon and my head is hurting me from a heavy night and the manuals are as clear as mud.
Thanks
Yahoo! Plus - For a better Internet experience
Murali Vallath
"We must be the change we wish to see in the world." Mahatma Gandhi.
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
