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@xxxxxxxxx> 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