Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
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
ogster1974
Partner - Master II
Partner - 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

cheenu_janakira
Creator III
Creator III

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.

cheenu_janakira
Creator III
Creator III

@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.