An automation task runs successfully when executed manually but fails when scheduled. The failure occurs during the export phase of a Select to File activity.
Observed behavior:
Example log: 4/27/2015 10:25:50 AM: Begin execution script activities
4/27/2015 10:25:50 AM: Begin Export of File_1
4/27/2015 10:25:50 AM: Connection established
4/27/2015 10:26:30 AM: File_1 - The network path was not found
4/27/2015 10:26:30 AM: Failed
The issue is caused by network access and mapping limitations during scheduled execution. When the automation runs in the background (such as via Task Scheduler or Toad automation scheduler), the process may not have access to the network location, even when a UNC path is used.
Although the UNC path is specified and the user has access, the system context running the automation may not properly resolve or maintain access to the network share.
Ensure the network location is properly mapped and accessible before running the automation.