Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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

Highlighted

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.

Highlighted
Contributor
Contributor

Hello, I have similar need.

Could you find any method?

Highlighted
Partner
Partner

Hi there,

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

Many thanks,

Riccardo

Highlighted
Contributor III
Contributor III

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!

Highlighted
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;

Highlighted
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.
Highlighted
Contributor III
Contributor III

Great solution, thank you for this!

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