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
Meteor

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

Meteor

Thanks for the idea! I'll try it tonight

Meteor

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!

Labels