Executing a Powershell script using Scheduler

Question

I am attempting to schedule a command line to run overnight that executes a powershell script.

* The scheduler is setup to run as my user when I am logged out of the machine.
* The scheduled task executes successfully (green light) but ultimately the end result of the powershell script is not executed.
* The Alteryx workflow executes successfully when I manually run the job.

Please let me know if you have any ideas on how to resolve.

Alteryx 1.PNG

Alteryx 2.PNG

jrgo · Answer

Oh I see. Yeah the run from "On disk" option is just to tell the scheduler where to grab the workflow to run from, but it will still execute and reference local resources within the scheduler machine.

Again, even if Excel is installed on the scheduler machine, it still may not work. I'd suggest researching the functions/commands your PS1 script is executing to see if they work when running as a background job or if it requires an interactive environment. If the latter, you may need to come up with another solution since scheduler always runs jobs as a system job in the background.

rcreed · Answer

I'm unsure if it is on the Windows Server. I know that we do not have the Alteryx Server so I am running the "desktop designer with scheduler" version. I do have the ability when I setup the scheduled job to run "on disk" or "in scheduler DB". The default is to run in scheduler DB so I tried to run it on disk this morning thinking that might get around your Windows/Excel idea but it yielded the same results.

jrgo · Answer

In regard to your scheduler, is that on an actual Windows Server running an Alteryx Server instance or something else?

Reason I ask is because I noticed that on the 4th screenshot, it looks to be calling some function that requires Excel. Common that an Server doesn't have Excel, or any other application not needed for Alteryx to operate, installed so when that powershell runs, it fails because it doesn't have applications available to do so.

If your Server does have Excel installed, the only other thing I can think of is that your function may not work when running as a background process and requires an interactive process in order to complete the script.

That said, I could be completely wrong, but is what comes to mind based off what I'm able to gather from what you've shared.