Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Reload Task to run every hour during business hours.

Hi Experts,

Can someone help me setup reload task trigger to run every hour during business hours (Mon-Fri) 08:00-17:00.

Regards, Nitin

4 Replies
Highlighted
Master II
Master II

I've not tried this but perhaps you could

1. Create a weekly task for 8:00am

2. Create one time tasks for each hour until 5pm

3. Create an on success trigger event task to link the weekly and the one time tasks together.

A bit of a faff but all the other options don't quite do what you need unless you manually set them up and I'm guessing you want to set this and leave it to run.

Hope this helps

Andy

Creator II
Creator II

If it is a back-end script (i.e. a QVD generator) have you considered an if statement so that it only fetches data at the times you require?

e.g. IF (WeekDay(TODAY()) <> 'Sat' OR WeekDay(TODAY()) <> 'Sun') AND (Hour(NOW()) >= 8 AND Hour(NOW()) <= 17) THEN

[whole script]

END IF;

Otherwise, Andy's solution is a workaround. Alternatively, although tedious, ten tasks one for each hour.

Highlighted
Highlighted
Creator II
Creator II

@ogster1974

For sure, this would only result in having to create 10 tasks. However, I was in a situation where some tasks had to launch every 15 minutes, some every half hour and some even every 45 minutes during work hours. The solution I conjured just prevents having to create one weekly task for each one of these that requires sub-hourly launches.

It's a "dirty" workaround, but the only one I could think off short of dabbling in some JS (which I don't know) to work directly through APIs.