I have an automation that runs fine from within Toad Data Point 5.0, but gives an error when running as a Scheduled Task. The automation is running a .bat file to check for the existence of a file (the file currently does not exist in the directory), if the file exists it processes the file and then moves it to an archive directory; if the file does not exist it errors with a return code of 2 and logs a message that the file does not exist.
Here is the log file when I run the automation from within Toad Data Point 5.0:
I get the message that the file does not exist as expected.
Here is the log file when I run the automation as a Scheduled Task:
When it tries to run the .bat file it errors with The directory name is invalid.
I am running Toad Data Point 5.0 on Microsoft Windows Server 2019 Standard.
The .bat file is on a mapped drive (Z:) to a MS Azure File Share.
I am sure that there is probably something very simple that I am missing, but I have tried everything I can think of. Any help would be greatly appreciated!!