Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: statspack auto starting/stopping
bduff_at_condenast.co.uk (Bruce) wrote in message news:<2df6b834.0204040645.3109ad95_at_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/
Received on Thu Apr 04 2002 - 14:53:47 CST