topic Re: Schedule automation for weekdays only in Qlik Automate

Schedule automation for weekdays only

Rfoot — Mon, 20 Feb 2023 03:15:47 GMT

Hi There,

I wanted to schedule my automation everyday excluding weekends. Is there advanced settings like in NPrinting that allows me to select weekdays only?

Thank you,

Ryan

Re: Schedule automation for weekdays only

AfeefaTk — Wed, 29 May 2024 06:12:32 GMT

Hi @Rfoot

We have an open improvement to offer more flexibility on the scheduling (every x days, day x of month, ..).

As a workaround, you can set the automation to run every day, use the condition block to check if the day is the weekend, and update the scheduling of your automation using the 'Update Automation Schedule' block in the Qlik Cloud Services connector.

Please find the example automation shared below

Import automation to your workspace and see how it works.

More information on importing automations can be found here.

Hope this helps

Thanks

Re: Schedule automation for weekdays only

Rfoot — Tue, 28 Feb 2023 23:09:01 GMT

Hi AfeefaTK,

This works great thank you but I live in a different timezone.

It seems to think my weekdays are tuesday to saturday and weekends are sunday to monday.

And if I use Australia in my scheduled timezone it doesnt seem to work.

Easy solution is to select friday and saturday as my weekend and this will correct my problem, but am I able to define my timezone in our automations to Australia timezone correctly?

Thank you.

Re: Schedule automation for weekdays only

AfeefaTk — Wed, 01 Mar 2023 05:52:05 GMT

Hi @Rfoot

You need to change it to your timezone to make it work

More information on allowed timezone can be found here

https://www.php.net/manual/en/timezones.php

For Australia : https://www.php.net/manual/en/timezones.australia.php

You need to set timezone in 2 places

One at the start block and the other at the Update Automation Schedule block

Thanks

Re: Schedule automation for weekdays only

skustes — Wed, 06 Mar 2024 17:43:05 GMT

Hi @AfeefaTk, I see you mentioned an open improvement to improve scheduling flexibility. One you mentioned that we need is "run on X day of the month." Another one that would be great if it isn't already on your list, is "every N months on X day of the month" to allow us to run an automation on a quarterly basis. Thanks!

Re: Schedule automation for weekdays only

Arwa_Elshahawy — Mon, 27 May 2024 21:17:56 GMT

thanks so much for the json file. i was wondering where do i specify the id of the app that should actually be reloaded. because in the 'Update Automation Schedule' you can only choose an Automation ID. Im still a bit unclear how to achieve the reload of my app. My exact use case is wanting to reload an app every 2 minutes but only on weekdays and working hours. Would be amazing if u can guide me through that @AfeefaTk @Rfoot

Re: Schedule automation for weekdays only

AfeefaTk — Wed, 29 May 2024 06:24:39 GMT

@Arwa_Elshahawy

You need to make some modifications to make it work.

For eg add "Do Reload" block from Qlik Cloud Services connector and modify the time interval between 2 runs to 2 minutes in the Update Automation Schedule block.

I have done some modifications and attached the modified automation workspace below.

Hope this helps!!

Thanks

Re: Schedule automation for weekdays only

Arwa_Elshahawy — Thu, 30 May 2024 13:53:33 GMT

@AfeefaTk Thank you so much for taking the time to reply to me. I've tested it and it only reloads the app according to the schedule that is defined in the start block (every day). so still i cant achieve the reload every 2 minutes. In the "update automation schedule" block under "schedule restart" its written "if", maybe i should write something there?
would be amazing i f u can give ma tip what should be written there to achieve the 2 minute reload.

Re: Schedule automation for weekdays only

OdieW — Thu, 12 Sep 2024 17:49:18 GMT

@AfeefaTk Any updates on the status of the improvement you mentioned? I'd like my automation to run every 10 days. I will try tweaking the condition method you mentioned, but just having a standard scheduling option that lets you choose the number of days sounds helpful.

Re: Schedule automation for weekdays only

tolange — Mon, 23 Sep 2024 19:17:50 GMT

While there is no native option, what also works and can accommodate any scheduling logic one can think of is creating the timestamp of the next run in a custom code block and updating the automation with it.