running multiple workflow one after another in Server

Question

Hello Team,

Please help me on below request! Struggling to get it done, any help would be really appreciated.

1. I have 5 workflows which is having dependency on each other, In particular, the Workflow 1 output is used in Workflow 2 input and similarly the workflow 2 output is used in workflow 3 input.

2. I want when I start running the Workflow 1, on its successful run it should call/start Workflow 2 to run. similarly, it would move forward.

3. If Any workflow throws any error, then it should not move forward with calling the next Workflow.

Please help me on the above requirement. will be waiting for your response.

Thanks

AJAY

TheOC · Answer

Hi @ajanayak 
I believe what you want is the Server Runner Macros (https://community.alteryx.com/t5/Engine-Works/Server-Runner-Macros/ba-p/889767). These allow for:

* Sequential Execution
* Simultaneous Execution
* Nested Execution

of workflows on your Alteryx Server.

Do note: If you're running these tools past version 21.4, you will need the macros on this article instead:
https://community.alteryx.com/t5/Engine-Works/Workflow-Orchestration-with-Alteryx-Server-2021-4-and-beyond/ba-p/952616

Hope this helps!

davidskaife · Answer

Hi @ajanayak

Have a look at this KB article - https://knowledge.alteryx.com/index/s/article/Chaining-Workflows-Together-1583460632768

If you have a Server you can make use of the 'Event' option and the AlteryxEngineCMD - however Server will not record the runs in the logs. This can be useful if you want to schedule the workflows.

If you do not have Server then the use of Crew Runner Macro's can be an option OR turn the workflows into Chained Apps, both options will need to be triggered manually.

Edit: didn't actually read the 'in server' part in the title, d'oh! At least you have some other options as well.