I have simple workspace routine that imports data collated from ArcGIS Survey123 (AGOL) and updates to a SQL server table that needs to run on a daily basis. Can this be done with a batch file (.bat) and scheduled with windows task scheduler?
Page 1 / 1
Yes, you can create a batch file and configure the Windows task scheduler to run it at any interval.
There are some helpful hints here, in particular the one from @stalknecht on how to configure the batch file:
https://knowledge.safe.com/questions/66476/run-fme-desktop-automatically-scheduled.html
It's important to verify that the scheduled task is executed with a user that has sufficient rights, see also:
https://knowledge.safe.com/questions/67628/fme-batch-file-works-but-not-via-windows-task-sche.html
A nice and easy way to get the content of your batch file is to run your workspace and stop it immediately, the first blue lines in the log window is what you need.
Just make sure it becomes one line in the batch file.
Hope this helps,
Itay