Hello,
How do I schedule a workflow to run on a bi-weekly basis?
Currently, there is no such option provided and it would be nice if this was added into the scheduler design.
Thanks!
That is a very old message. We do have the ability to schedule multiple days a month with the Custom option.
At this point it looks like you would have to schedule twice; once for each time you want it to run in the month.
Not cool! Please add this to the scheduler's design under "Frequency" drop-down.
While I do see the value in the custom option, a true bi weekly option would just be better. If I want to have a report run every two weeks on Friday, that day of the month is going to fluctuate over time and I'm not going to be able to have it send every other Friday.
Hi,
Were you able to figure out how to run a workflow on weekly schedule without having fixed dates to run
I have a similar requirement and not sure how to achieve this
Any help on this would be appreciated !!
Cheers
Shalika
I resolved this issue by using PostgreSQL generate_series, then set the Alteryx scheduler to run every Monday, so on the weeks that are not my desired bi-weekly date, it will not run.
I provided the first date that I wanted to run the bi-weekly report and use that to build my series, so that I have the bi-weekly dates.CASEWHEN current_date IN (SELECT GENERATE_SERIES('2022-05-02', (current_date + interval '1 week'), '2 weeks'::INTERVAL)::date)THEN 'Y'ELSE 'N'END AS run_today
Could the above be rewritten to fit in a formula tool ?
To truly get my workflow to publish every 14 days (every other Friday), I had to use a Detour tool macro that checks if the a publish flag is set to 'True' or 'False'. If [Today] = [Next Publish Date], then Publish flag is 'True' and the workflow takes the path to the right. Configure this right path to publish a report or whatever you need, as well as update the 'Last Publish Date' file.
When the Publish flag is 'False', the workflow takes the left path with no reporting or output tools so nothing happens. Schedule to run daily and only when [Today] = [Next Publish Date] is 'True' will any output or report actually publish.
Simply set a schedule to run every 336 hours.
(336 hours = 24h x 14d)
Best regards,
Léo Carné
There is actually a pretty simple work around. If you don't mind the workflow running every week and just not doing anything for half the weeks. Put a filter right after your inputs and add something like this:
mod(tonumber(datetimeformat(datetimetoday(),'%W')),2) = 0 //run on even weeks
or
mod(tonumber(datetimeformat(datetimetoday(),'%W')),2) = 1 //run on odd weeks
That's How I did it when I needed to run a job every 28 days. Set it to 672 Hours
