Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi community,
I've got an scheduler at the ETL stage where I at the extract stage would like to perform the procedure 2 times a day. At 8.30 am and 10.30 am.
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...
Cheers
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.
Yes sorry I have made a setup on going hourly starting at 06.20 so every hour 20 past: 07.20, 08.20 and so forth
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:
load qlikview server more than once a day at sp... | Qlik Community
Please remember to mark this as helpful or the correct answer if I have helped you or answered your question.