community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Scheduling a Workflow with a Powershell Script

Highlighted
Asteroid

Hello Everyone,

 

I have a workflow that runs a simple powershell script that moves, renames, and deletes some files at the end of a workflow.  It works without error when I manually run the workflow, but when I schedule it (I have designer with desktop automation) to run at night when the computer is locked, I get an error.  I have attached a screenshot of my Run Command tool and workflow results.

 

Has anyone come across this before?  It's probably a Powershell problem.

 

Thanks,
Ken

Alteryx Certified Partner

Issues like this are typically related to credentials. The link below shows how you can specify the credentials for Scheduler to use to make sure powershell has the permissions it needs.

 

https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/Run-As-Settings/ta-p/17830

Asteroid

Thanks for the idea! I'll try it tonight

Asteroid

So I made the change in the advanced settings, but it did not work overnight.

 

When I came in this morning my computer no longer saw it self as a Controller.  The service was frozen in a 'Stopping' state.  So I changed the service to use my ID as well and rebooted my machine.  The scheduler picked back up and ran the job after that.

 

Thanks!

Atom

Hi,

 

Do you know how to schedule a workflow using powershell.

If so, please let me know.

 

Thanks,

A**bleep**a

Asteroid

Hi aj9,

 

Not sure what you mean.  Do you want Alteryx to run a PowerShell script on a schedule?  This I know how to do.

 

Or do you want PowerShell to schedule a workflow in Alteryx?  This I don't know how to do.

 

Thanks,
Ken

Alteryx Certified Partner
Alteryx Certified Partner

@aj9 it is not possible to schedule an Alteryx workflow (with any software inc. external scripts) to run without either a scheduler add-on license or a server license.

 

Ben 

Atom

Hi,

I want PowerShell to schedule a workflow in Alteryx.
I am not having license for scheduler and hence no access to AlteryxEngineCmd.exe, but I need to schedule alteryx workflow.
Do you know any other method to schedule alteryx workflow?

Thanks

Hello @BenMoss

 

Alteryx Certified Partner
Alteryx Certified Partner

@aj9 it is against the license agreement to create a schedule without the appropriate add-ons. 

 

@harshal_narkhede I'm definitely not the best person to ask about that! Is there an issue with scheduling using the standard interface?

Labels