Run workflows one after another

[pgeorge4]

Hi,

I have alteryx designer and server.

I have created a workflow to test whether a .txt file exists in a folder and based on that if the exists then I want to trigger another workflow.

I have added other workflow in the Event after run without error.But when I try to execute it says  Designer x64 The Designer x64 reported: Error running Event #1: The external program "C:\Program Files\Alteryx\bin\AlteryxEngineCmd.exe" returned an error code: 2: The system could not find the environment option that was entered. ¶ (203)

My alteryx designer license is not enabled with API and scheduler feature. Please check the attached item.

Is there any tool I can use to chain the workflows without events?

I have attached the screen shot of the first marco which checks for a file.

Regards,

philip

[JordanB]

Hi @pgeorge4

Is publishing/scheduling this workflow to the server an option? This will have the correct license to enable this feature. 

Best,

Jordan Barker

Solutions Consultant

[pgeorge4]

Hi,

I am able to do a save as to the Alteryx server Gallery. We have alteryx server .

Also I am able to schedule the workflow connecting to Alteryx server as as a controller.

With these features how can I enable running the workflow in a chain.

Regards,

philip

[AdamR_AYX]

You could also check out the runner macros in the CReW macro pack (http://www.chaosreignswithin.com/2014/09/blog-macro-pack-2014-q3-release.html for a quick overview)

Download the latest version of the macros from here http://www.chaosreignswithin.com/p/macros.html

Just a note that these aren't an official part of the product or officially supported, but they are widely used.

[SteveKnapper]

Hello, I have the same requirement where I have six workflows which need to be ran in order.

They are published to our gallery.

But are not scheduled as I do not know how long each step takes.

I have been reluctant to use the third party macros as do like to use the gallery scheduler and have read that these are not compatible.

steve

[JordanB]

Hi @SteveKnapper

You can use the events tab to call upon a workflow. You can find an article explaining it here, you will want option 2 after the Crew Macros

Best,

Jordan

[StephenSink]

This article isn't much help if you're trying to work with workflows published to a server. The Runner tool is not compatible with with the scheduler:

" Using Runner Macros on an Alteryx Server or Gallery can risk over-utilization of resources and cause instability in an Alteryx Server or Gallery environment and thus Runner Macros are not supported on Alteryx Server. There are other options that will allow you to use the workflow on the Gallery or Scheduler."

In the Run Command Event, you need to specific a file path which is not possible with a workflow on the server.

The interface tool has a default timeout of 30 seconds so if workflow 1 takes any longer then 30 seconds then this options doesn't work well either (default time out can be changed but has to be done by server admin).

So far i haven't found any good solution to this problem.

[jamshed23]

is there any good solution to chain worfkow? i have more than 50 workflow which required need to run in order

[_Angus_Birnie]

is it possible for you to combine workflows that need chaining and use control containers to set the order in which the groups of workflows run?