I've searched for a way to do this using Automate but I can't seem to find it.
I have a batch file I need to run from my Automate server on a remote server. When I run the script locally (on the application server) it works just fine. The vendor suggests running the batch file using Windows Scheduler which I can do but I would rather use Automate if possible because when this batch file is done the is some additional file renaming and moving I need to do in Automate anyway.
The exact script has nothing that can't be shared so I'll paste in the exact script that works when I run it on the application server. Please note the file paths are the paths for the remote application server, not the Automate server.
cd "c:\Program Files\Risk & Performance Solutions\Vantage\VantageConfig"
Vantage.Config.exe -Action "BackupDatabase" -DatabaseList "VANTAGE_PROD" -VCMParameterList "SRV-VANTAGE,," -AuthMode "Windows" -BackupFile "C:\Vantage Backups\Vantage_Production.vantage" -Overwrite "true"
I attempted to just past that script into Execute Basic script (changing the file path to the remote UNC path) but it didn't work. Any help can be appreaciated but if this isn't supported I'll just have to run it in Windows Scheduler and then let Automate separately launch for the post batch steps.