Scheduling a Workflow with a Powershell Script

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

Powershell Issue.png

Results.png

Developer Tools

Error Message

Scheduler

Run Command

Accepted answers

CharlieS

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

All comments

CharlieS

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

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

preeti121288

I am also facing the same issue while running Alteryx workflow in Alteryx Gallery which is having PowerShell script. Workflow runs fine in my machine but on gallery it is giving same error as mentioned in above query.

"Run Command (4) The external program "powershell" returned an error code: 1"

does anyone has any solution for this?

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703