topic Re: Reload Schedule Limit To Certain Times Of The Day in QlikView

Reload Schedule Limit To Certain Times Of The Day

rebelfox — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Reload Schedule Limit To Certain Times Of The Day

lironbaram — Sun, 19 Jun 2016 07:54:50 GMT

hi if you use

qlikview management console then you can only define one reload schedule to each app

and there is no way to prevent it from running all day

there are two ways to solve the issue

1. use qlikview publisher which will allow more advanced scheduling , this solution of course means you need to purchase a license .

2. you can create a very simple up the check the time of the day and if the time is in the time window it'll finish the load process ok either wise it'll fail

then in your qlikview management console define this up to load every 30 minutes and your actual app to run only if this app reload is successful , by this method it means that half of the day when entering the qmc you'll see an app that failed to load

Re: Reload Schedule Limit To Certain Times Of The Day

Sun, 19 Jun 2016 08:07:13 GMT

Hi Roy,

The technique that roiuser‌ has mentioned is the best solution without publisher.

I am using the same technique as we don't have publisher.

Re: Reload Schedule Limit To Certain Times Of The Day

Peter_Cammaert — Sun, 19 Jun 2016 15:55:53 GMT

If you don't like the spamming caused by all those reload failures outside of the 7am-to-7pm window, you could consider a third alternative: Windows Task Scheduler pinches tasks that - using QMSEDX Enhanced | Qlik Community - are triggered "by an external event". Almost Publisher-like scheduling flexibility, but no more configuring schedules inside the QMC.

IMHO a Publisher license is the best solution to create complex task dependencies and schedules. Keep this in mind when facing even more complex scheduling/distribution requests from your end-users in the future.

Best,

Peter

Re: Reload Schedule Limit To Certain Times Of The Day

maxgro — Sun, 19 Jun 2016 18:33:20 GMT

Maybe: split the .qvw in 2 .qvw

The first one reads from AS400 and store in qvd files

The second (starts when the first finishes successful) reads the .qvd

Add an if to the first .qvw (check the time):

if time between 7 am and 7 pm

read and store in qvd

else (between 7 pm and 7 am)

do nothing (--> no AS400 read)

At the night, the second .qvw will run every 30 minutes but will read the 7 pm .qvd

Re: Reload Schedule Limit To Certain Times Of The Day

rebelfox — Mon, 20 Jun 2016 07:46:30 GMT

Do you have a link for this solution?

Thanks

Roy

Re: Reload Schedule Limit To Certain Times Of The Day

rebelfox — Mon, 20 Jun 2016 07:47:09 GMT

Yes that's a good idea.

Thanks.

Re: Reload Schedule Limit To Certain Times Of The Day

Mon, 20 Jun 2016 10:36:07 GMT

Hi Roy,

I don't have a link but I can guide you based on what I have done in the past..

Create a QVW Application and name it QVD Generator (This application's job is to only generate QVD files)
Add if else statement in the connection string of that application as maxgro‌ has mentioned.
Make this QVD Generator to reload every 30 minutes.
Then make all your other QVW Applications to reload only if that QVD Generator application reload task is successful.

Hope it helps.

Re: Reload Schedule Limit To Certain Times Of The Day

rebelfox — Mon, 20 Jun 2016 12:50:30 GMT

Very much thankyou.

Re: Reload Schedule Limit To Certain Times Of The Day

rebelfox — Mon, 20 Jun 2016 12:51:04 GMT

This is the one I found most suitable on balance.

Thanks.

Re: Reload Schedule Limit To Certain Times Of The Day

bergmcjgt — Mon, 30 Dec 2019 19:11:42 GMT

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.