Skip to main content
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Schedule task between specific hours

Hello,

Is it possible to create in sense a task that runs several times (hourly, every x minutes, etc) between specific hours?

This option was available in qlikview publisher triggers (for example when we select Hourly, this option would appear "Run only between [...] and [...])

Thanks.

18 Replies
karthikoffi27se
Creator III
Creator III

Hi Ruben,

You need to set the Start Date and the End Date and the type of Schedule you require which is available in QlikSense QMC..Screen short attached below

Screenshot.PNG

rubenmarin

Thanks Karthik, I know...there should be a kind of confussion as I wasn't the one doing the initial question, I was trying to help JP.

Regards.

cistanbulluoglu
Contributor
Contributor

Hello, I have similar need.

Could you find any method?

rzenere_avvale
Partner - Specialist II
Partner - Specialist II

Hi there,

anyone found a solution with latest versions of QS (September/November 2017)?

Many thanks,

Riccardo

martinsandin
Employee
Employee

Hello Riccardo!

In Sense this is not possible to do using the UI.

If you are only have a moderate number of times you want to trigger it every day then you can work around this problem by creating a separate trigger for each such occasion and space the start times say 15 minutes apart.


If you can't use that solution then there is an API endpoint for starting tasks mentioned above and you can use e.g. cron+curl to call it according to your own schedule.

Good luck!

pjaredchurch
Contributor III
Contributor III

I know this is an old question, but I don't see any clear solution given, so here goes...

I had a requirement to have an app load on a short cycle (5mins) within normal business hours, and no point loading outside of those hours (because the app takes 4mins to load it would be very "expensive" to have it load at times that don't matter).

I used two apps to make this happen:

App 1: scheduled to run every 5mins, and will complete successfully if current time of day is within business hours, and fail if current time of day is outside of business hours.

App 2: will schedule based on App 1 completing successfully.

 

Here is reference code for App 1:

let vUpperBound=timestamp('21:05','hh:mm') + 0;
let vLowerBound=timestamp('05:55','hh:mm') + 0;

let vNow=now() - today();


trace $(vLowerBound) < $(vNow) < $(vUpperBound);

if $(vNow) > $(vLowerBound) and $(vNow) < $(vUpperBound) then
trace Succeed;
exit script;
else
trace Fail;
Intentional Failure;
end if;

CGilQlik
Contributor II
Contributor II

Hello everyone!
We used the same approach for a similar request and it worked fine.
It would be great to have this option in the triggers, like in monthly or weekly options that let you select individual values.
tyember1
Contributor III
Contributor III

Great solution, thank you for this!

pjaredchurch
Contributor III
Contributor III

I've moved to using the QRS API now.

 

I am using windows scheduler to trigger a powershell script that runs a QlikSense task through the API.

The benefit of doing it this way is that I don't get log files filled up with task failures that are intentional.