Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 

Reload Schedule Limit To Certain Times Of The Day

I have Qlikview report that reports from a legacy Iseries/AS400 database.

Users want the report updating regularly with updates which means I have set up a management console schedule to run every 30 minutes.  However there is no value in running from 7pm to 7am as there are no users to use it and worse still it can cause problems for the Iseries backup if a read lock is placed on files overnight.  Is there a way to set up a schedule to run the report every 30 minutes but within a time frame of 7am to 7pm?

10 Replies

I have added to this same function by creating a MySQL database.  All of my scripts begin by reading the database with a simple SQL that returns a true or false. I then peek the results and follow the "if else" process described here. Very neat and simple method of controlling reoccurring tasks.