Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

rickwild
Contributor

Schedule reload for workdays only

I have a QVW that I want to reload every hour, but only during working days. Overnight and at weekends I don't want it to reload at all.

Can I achieve this with the QV Server reload scheduler, or will I need to control it externally?

1 Solution

Accepted Solutions
MVP
MVP

Schedule reload for workdays only

QlikView Publisher can run Monday through Friday and only between particular hours on those days. I don't know of any way to give it a holiday list to skip, though, so it would still be running a little more often than you probably want. I also don't know if you have QlikView Publisher, since that wasn't specifically what you asked.

5 Replies
martin59
Valued Contributor II

Re. :Schedule reload for workdays only

I think this reload frequency is not possible with QVS, you have to do it with another task scheduler.

rickwild
Contributor

Re. :Schedule reload for workdays only

OK - merci Martin.

Employee
Employee

Schedule reload for workdays only

You could go back to the old way. Use the QlikView commandline feature and Microsoft scheduler.

MVP
MVP

Schedule reload for workdays only

QlikView Publisher can run Monday through Friday and only between particular hours on those days. I don't know of any way to give it a holiday list to skip, though, so it would still be running a little more often than you probably want. I also don't know if you have QlikView Publisher, since that wasn't specifically what you asked.

rickwild
Contributor

Schedule reload for workdays only

Thanks to all responders.

I don't have Publisher, but thanks for the info anyway.

In the end I put a test at the top of the script to see what day/time it is, then do an exit script if it's overnight or weekends. This particular qvw only extracts data into QVDs, so that works fine.

I haven't tried it yet, but I think that if I make downstream apps reload dependent on a successful run of the initial data extract I can control the whole thing this way.

I haven't tried figuring in public holidays - maybe in phase2Smiley Wink