Niklas Söderqvist wrote:
Anyone got experience on doing this? At the moment I have scheduled it once every hour at 20 past. But this is unnecessary and i'm afraid i'd take up server performance or issuing any deadlocks...
I didn't understand the Bold part. Would you please elaborate bit more. I got the experience to create the schedule dependency tasks.
You can always pop in a little check at the start of your script, something like (edited all my junk out)
if HOUR(now()) <> 8 OR HOUR(now())<>10 THEN EXIT SCRIPT END IF
Leave it scheduled every hour and it'll only run when you want. We use this method to do a full data reload at 2am, but during the day it just runs our incremental script.
There are some good ideas here as well:
Please remember to mark this as helpful or the correct answer if I have helped you or answered your question.