Re: How do I turn off STATSPACK auto snapshots on 8.1.7

You should query the rows in the dba_jobs to find the job id, then use dbms_job.remove(jobid) to remove the job, and query the dba_jobs again to make sure you remove the job.

On 9/14/05, Larry Kelly <ldk2005_at_gmail.com> wrote:
>
> I want use STATSPACK as part of my tuning strategy. The spauto.sql script
> will schedule periodic snapshots. I'm hesitant to start it until I know how
> to stop the automatic snapshots.
>
> --
> Best Regards,
> -Larry
> "Work, work, work...there is no satisfactory alternative."
> --- E.Taft Benson

-- 
Welcome, Fangxin.Lou from China
MYDUL, alternative to DUL !!!
Home: http://www.anysql.net/en/
Mydul: http://www.anysql.net/en/mydul.html

--
http://www.freelists.org/webpage/oracle-l