Automation is created and when manually run, there is no issue.
But when scheduled, the automation will error randomly. When it does occur, it will occur on the first activity. The activities used is the "select to file" option. In this activity, it is specified to save the data as a file on the network. When run, Toad errors out with:
"File_1 - The network path was not found."
The automation seems to start, the log showes that connection is made and execution script activity starts. But when the export starts, it errors out.
Sample:
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 description = ALVTOAD2864SR09 (sa)
4/27/2015 10:25:50 AM: Connection node found
4/27/2015 10:25:50 AM: Connection to: ALVTOAD2864SR09 (sa)
4/27/2015 10:25:50 AM: Begin Export
4/27/2015 10:26:30 AM: File_1 - The network path was not found.
4/27/2015 10:26:30 AM: Failed