Calling Alteryx Server from Command Line in ESP

patrick_mcauliffe

One of our users needs to be able to run Alteryx from the command line as part of a longer process running from ESP (our enterprise scheduler).

The Alteryx workflow needs to run on our server.

In order to make that happen; does this need to run on the Controller or a Worker?

Are there any risks?

My concern is with running it on the controller - would we be effectively tying up a resource needed to send jobs out to workers?

JulieM

Hi @patrick_mcauliffe, this can be achieved by using the AlteryxService.exe command line interface to run these workflows.  The addtoqueue command will schedule a workflow for immediate execution by placing the job into the execution queue on your controller.  You won't need to designate whether the workflow is run on the Controller or a Worker as the Controller will handle the queuing of the jobs which are then automatically picked up by the next available worker.  This behavior is a lot like when a workflow has been scheduled to run using the Alteryx Scheduler.  Here's a link to a Community post on the Server command line that you might find helpful: https://community.alteryx.com/t5/Engine-Works-Blog/Intro-to-the-Server-command-line/ba-p/13380.  I hope this helps and feel free to let us know if you have any additional questions!