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?