Restart workflows after crash

Question

Please advise, how can we manage automatically restarting of workflows in case of crashing.

Imagine situation:

* we have scheduled workflow.
* Workflow runs due to schedule.
* During running some crash happened:* data source|target is unavailable,
* service is unexpectedly stopped, etc.

* We have to restart crashed workflows to repeat data processing in two cases:* when workflow is finished with error
* when service crashed/restarted - to resume/restart crashed workflows

How can we do it? For example - set up several attempts until success.

AndreyBaburov · Answer

Thanks for response.

Can I somehow manage gallery schedule from command line?

If I use Events option, I would like to not run workflow immediately after Errors, but schedule it one hour later via Gallery API.

echuong1 · Answer

There is not an "automatic rerun" option available. However, you can replicate this using the Events option.

Essentially, you can add an event to run after the workflow completes with errors. You'd create an event to use the Alteryx engine command along with the workflow to run after this failure. It would keep doing this until successful. See this link for more information:

https://help.alteryx.com/current/designer/run-workflows-command-line

Other options are to use the Conditional runner Crew Macro or to schedule your workflow to run every couple of minutes.

Hope this helps!