Scheduling Workflows to Run in Succession

Hi,

I've been tasked to test a trial version of the Alteryx Server to determine if it's worth purchasing.

I've been told that workflows can only run one-at-a-time. Assuming that this is true, does it have to be that schedules will be set at intervals - estimating the time a workflow is set to finish, before scheduling the next?

Example:

Workflow 1 - 1:00 AM - Estimated Time: 1 hour

Workflow 2 - 2:00 AM - Estimated Time: 30 minutes

Workflow 3 - 2:30 AM - Estimated Time: 1 hour

Is there another way to do this? Can I "schedule" workflows to run at the same time and let Alteryx just run them in succession?

Example:

Workflow 1 - 1:00 AM - Estimated Time: 1 hour

Workflow 2 - 1:00 AM - Estimated Time: 30 minutes

Workflow 3 - 1:00 AM - Estimated Time: 1 hour

Server

Best Practices

Scheduler

Accepted answers

gabrielvilella

Hi @RonGatmaitan, if your Alteryx Server was set to not have cuncurrent jobs, your first example will work, one job will not start until the last one has finished. However, if you want to trigger a job as soon as the last one has finished, it is not possible to do this by default.

There is a way of achieving this, but it requires the installation of aditional macros (Crew macros) both on the Designer and the Server machines. On this case you have a workflow that will orchestrate the run of those other workflows. However, this is not officially supported by Alteryx (article).

Finally, there is another way of doing this using APIs. This article helps you doing that (link).

All comments

gabrielvilella

Finally, there is another way of doing this using APIs. This article helps you doing that (link).

RonGatmaitan

Hi @gabrielvilella,

Thanks for the reply. I don't think we have the additional crew macros, that's why I was told to run it one after the other.

Now my concern is, what if the second workflow's time occurs while the first one's is still running? What will happen then? The problem is, those times are just "estimates". I have no control as to what time they actually finish.

gabrielvilella

If your Alteryx Server was set to not have cuncurrent jobs, one job will not start until the last one has finished.

RonGatmaitan

Hi @gabrielvilella,

So can I just schedule them all at the same time and just let Alteryx run them one after the other?

gabrielvilella

If you have one workflow that requires another one to have finished first, I'd recommed to schedule for a minute later than the first one, for example.

RonGatmaitan

What if they're independent of each other? Is it okay to set them all at the same time and let Alteryx sort it out?

gabrielvilella

Yes.

RonGatmaitan

Thank you, @gabrielvilella!

Setting your answer as the accepted solution. 🙂

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703