topic Re: Schedule task between specific hours in Management & Governance

Schedule task between specific hours

Thu, 28 Jul 2016 11:07:00 GMT

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.

Re: Schedule task between specific hours

karthikoffi27se — Thu, 28 Jul 2016 11:45:09 GMT

Hi JP,

Thanks for your email.

Click on the Action function and then edit.

And then in Schedule tab...

Hourly ----->> Repeat after Each hours -->> (Include every hour)

----->> Minutes ---> (30) --> (Specify the minute(s))

In that way you can schedule the hours you want...

Many Thanks

Karthik

Re: Schedule task between specific hours

rubenmarin — Thu, 28 Jul 2016 12:17:42 GMT

I don't have access now to a sense server but in the trigger there are fields to enter the start and end of a task, can you try to set there a time without a date and check if works as expected?

Re: Schedule task between specific hours

Thu, 28 Jul 2016 12:27:18 GMT

Hi Karthik,

Thanks for replying.

I'm already using this option to make the task run every 15 minutes.

But my request is to set a daily start/end time for the task executions.

I want it to run let's say every 15 minutes but only between 9:00 AM and 7:00 PM.

Re: Schedule task between specific hours

Thu, 28 Jul 2016 12:29:16 GMT

Hi Ruben,

Apparently, the date is mandatory.

This could've been a logical solution though.

Re: Schedule task between specific hours

karthikoffi27se — Thu, 28 Jul 2016 12:33:09 GMT

Hi Ruben

Are you having a desktop version of QlikSense?

Many Thanks

Karthik

Re: Schedule task between specific hours

rubenmarin — Thu, 28 Jul 2016 12:59:13 GMT

I searched in the community and this post says it's not possible using GUI (at least in 2.0)... but an API can be used.

I don't know how the hours works, in example if you set from 08:00 2016-07-01 to 15:00 9999-12-31 --> I don't know if this will work every day between the specified hours or the start hour it's only for the first time (in 2016-07-01). I think it will deserve a try.

Re: Schedule task between specific hours

Thu, 28 Jul 2016 13:14:59 GMT

Yeah, tried that too.

I've set an end time with a future date.

The task kept running after that time.

Seems the end time/date specifies when this task won't be executed anymore.

Thanks for mentioning the other post, I'll have a look at it.

Re: Schedule task between specific hours

rubenmarin — Thu, 28 Jul 2016 18:41:23 GMT

Hi Karthikeyan

Yes, I have a desktop version but I don't have a qmc to check.

Regards.

Re: Schedule task between specific hours

karthikoffi27se — Fri, 29 Jul 2016 05:21:46 GMT

Hi Ruben

Currently, there isn't option to schedule in Desktop version.

Many Thanks

Karthik

Re: Schedule task between specific hours

karthikoffi27se — Fri, 29 Jul 2016 05:28:47 GMT

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

Re: Schedule task between specific hours

rubenmarin — Fri, 29 Jul 2016 08:16:40 GMT

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.

Re: Schedule task between specific hours

cistanbulluoglu — Wed, 06 Dec 2017 11:10:27 GMT

Hello, I have similar need.

Could you find any method?

Re: Schedule task between specific hours

rzenere_avvale — Tue, 30 Jan 2018 10:19:54 GMT

Hi there,

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

Many thanks,

Riccardo

Re: Schedule task between specific hours

martinsandin — Tue, 30 Jan 2018 14:50:02 GMT

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!

Re: Schedule task between specific hours

pjaredchurch — Wed, 21 Nov 2018 19:59:58 GMT

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;

Re: Schedule task between specific hours

CGilQlik — Thu, 29 Nov 2018 15:31:27 GMT

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.

Re: Schedule task between specific hours

tyember1 — Thu, 14 May 2020 14:33:17 GMT

Great solution, thank you for this!

Re: Schedule task between specific hours

pjaredchurch — Thu, 14 May 2020 20:25:22 GMT

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.