I have just installed Statspack on my Prod dbase. Everything is setup and ready to roll. One of the questions I have and cant seem to get an answer for is as follows:
I want to set the Snapshots so it automaticaly starts at say 9:30am (snap id 1) and finishes at 7:00pm(snap id 2). I can then run the report the following day and archive them off etc. My database gets shutdown each night to do a full backup so I need to start the snapshot at the start of each day. I hope this makes sense.