topic Re: Can a fail event be used to set the workflow to re-run in 30 minutes on server in Alteryx Server Discussions

Can a fail event be used to set the workflow to re-run in 30 minutes on server

wwatson — Tue, 11 Aug 2020 13:14:28 GMT

Can we set a workflow to re-run after a specified number of minutes after a fail event on Alteryx Server? I see the following 2 options under workflow events.

Re: Can a fail event be used to set the workflow to re-run in 30 minutes on server

JustinBabbitt — Wed, 12 Aug 2020 11:50:49 GMT

@wwatson

I'm not sure that is an option. It may be more helpful to program around the specific cases that would cause the scheduled workflow to fail.

I'm happy to help brainstorm if you are willing to share more about the situation.

Justin Babbitt

Re: Can a fail event be used to set the workflow to re-run in 30 minutes on server

wwatson — Wed, 12 Aug 2020 12:04:37 GMT

A critical workflow might fail on Server due to a file not being available, a network connection problem or something else. We want to know if we can automatically trigger them to run again after a specified period like 30 minutes. I couldn't see any obvious way to configure this on server. Any ideas would be appreciated.

Re: Can a fail event be used to set the workflow to re-run in 30 minutes on server

JustinBabbitt — Wed, 12 Aug 2020 13:26:26 GMT

Unfortunately, I don't think there is an obvious way to configure the scheduler in the way you are describing.

It is possible to run Alteryx from the command line though...

I'm not well versed on creating .bat files so I'll pose this question: Would it be possible to set up a .bat to execute on Failure (Event) that has a time dimension. So it would execute something like this:

Start .bat

Get start time

Wait 30 mins

Execute Alteryx Workflow

Another idea is to potentially identity why a workflow failed and Create Messages in the workflow to help decipher what happened, then Send the fail message to yourself (Or whomever) using the Email Tool.

Re: Can a fail event be used to set the workflow to re-run in 30 minutes on server

wwatson — Wed, 12 Aug 2020 16:15:20 GMT

@JustinBabbitt we already have fail event emails set up so we know when one of the critical workflows fails. The action for some of them is always the same, run it again in 30 mins.

We'd like to automate running the workflow again after a fail.

I'll ask around internally about a bat file option.