Scheduling a Workflow with a Powershell Script

[kgalbert]

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

[CharlieS · Accepted solution]

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

[kgalbert]

Thanks for the idea! I'll try it tonight

[kgalbert]

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!

[aj9]

Hi,

Do you know how to schedule a workflow using powershell.

If so, please let me know.

Thanks,

A**bleep**a

[kgalbert]

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

[BenMoss]

@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 

[aj9]

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

[harshal_narkhede]

Hello @BenMoss,

I do have the scheduler add-on license, server license. What's the procedure to proceed from this? Thanks in advance!

[BenMoss]

@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?