Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
RickWild64
Partner - Creator
Partner - Creator

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
johnw
Champion III
Champion III

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.

View solution in original post

5 Replies
martin59
Specialist II
Specialist II

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

RickWild64
Partner - Creator
Partner - Creator
Author

OK - merci Martin.

Bill_Britt
Former Employee
Former Employee

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

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
johnw
Champion III
Champion III

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.

RickWild64
Partner - Creator
Partner - Creator
Author

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 phase2;)