I have configured Statspack on my 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...
Click Here to Expand Forum to Full Width