Automation: running EG projects in headless mode via SSH

[Frank09]

Thanks! We previously use Windows Task Scheduler to schedule many VBscript files.  There are some limitations on using Windows Task Scheduler. So we decide to switch to Airflow. However, SAS programmers don't want to change the existing VBscrit files.  

[AlanC]

Run some of the scripts through CoPilot and ask it to translate them to PowerShell. It should get you over 90% there with little effort. I use it to do VBA to C# and it does a decent job for specific tasks. 

The scheduler has nothing to do with VBScript (unless I missed something). You can run any scheduler. For EG work, I use a combination of C# and PowerShell but many people would be comfortable with PS. You then just schedule your PS job. 

[Frank09]

Thanks! I think it's a good idea of using CoPilot to generate Powershell based on VBscript. I will try it in future.

I agree with you that Scheduler has nothing to do with VBscript. But when using OpenSSH to connect the two things, something may be different, especially one side is on Windows system. 

[js5]

Hi all,

we tried powershell as well and got the same problems. The scripts run locally without problems, but fail when triggered via SSH. With psexec we could also start the scripts locally but not from an ssh session.

[Frank09]

I think the problem is related to SSH connection. If using admin/password authentication, the scripts can be executed successfully.  But non-admin can't even though it can run the scripts in local command prompt.