Re: submitting statspack.snap through dbms_job

From: Murali Vallath <murali_vallath_at_yahoo.com>
Date: Sat, 05 Apr 2003 04:18:37 -0800
Message-ID: <F001.0057B3E9.20030405041837@fatcity.com>

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 <roon987_at_yahoo.co.uk> 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!
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Murali Vallath
  INET: murali_vallath_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Sat Apr 05 2003 - 06:18:37 CST