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
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.
ThanksYahoo! Plus - For a better Internet experience
Title: Re: submitting statspack.snap through dbms_job
var jnr number
exec dbms_job.submit(job=:jnr, what='statspack.snap(5);',
next_date=trunc(sysdate)+10/24, interval='trunc(sysdate)+10/24');
exec dbms_job.submit(job=:jnr, what='statspack.snap(5);',
next_date=trunc(sysdate)+14/24