I have an automation script set-up that does a basic query and then exports a text file using an export template.
When clicking the “Test” button to execute the automation script, it successfully executes.
When I schedule the exact same job, it fails with error message “The process cannot access the file…because it is being used by another process.”
The export template is set to overwrite an existing file. The scheduled job will fail regardless if there is or is not an existing file already in the destination folder. On the other hand, it will execute successfully when I manually click the Test button regardless if there’s an existing file or not.
Any suggestions would be greatly appreciated.