Path: news.easynews.com!easynews!news.he.net!cyclone-sf.pbi.net!64.245.249.51!sfo2-feed1.news.algx.net!allegiance!logbridge.uoregon.edu!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: oraclems@hotmail.com (Murali)
Newsgroups: comp.databases.oracle.server
Subject: Re: statspack auto starting/stopping
Date: 4 Apr 2002 12:53:47 -0800
Organization: http://groups.google.com/
Lines: 21
Message-ID: <22e6597b.0204041253.4425ee37@posting.google.com>
References: <2df6b834.0204040645.3109ad95@posting.google.com>
NNTP-Posting-Host: 64.2.235.34
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1017953627 10801 127.0.0.1 (4 Apr 2002 20:53:47 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 4 Apr 2002 20:53:47 GMT
Xref: easynews comp.databases.oracle.server:142085
X-Received-Date: Thu, 04 Apr 2002 13:51:34 MST (news.easynews.com)

bduff@condenast.co.uk (Bruce) wrote in message news:<2df6b834.0204040645.3109ad95@posting.google.com>...
> I have configured Statspack on my hp-ux 8.1.7.1.0 Oracle dbase. I'm
> manually starting the collector on a daily basis using @spauto.sql.
> This is fine to an extent. I now want to start it automatically using
> a cron job and say run it between the peak operating hours of 9 and 5.
> I should be able to do this.
> 
> However, I'm not sure about killing this job each night before the
> backup at 9pm. We have a cold backup in place which obviously stops
> it. I would ideally like to restart it the next day at 9am using cron.
> 
> Has anyone else out there done this? or do you have any other ideas? 
> 
> Thanks in advance...

Why dont you run it between just 9 and 5 PM ? In the "hour" field of
your crontab, put 09-17. Try "man crontab" for full syntax. Dont see
why you have to kill the job....

Murali
http://www.dbaquest.com/