SQL Server job running script file never finishes.
My script file to get a file from an FTP site works great from command prompt and worked great for 2 weeks from SQL Server 2005 job. Sometime around when the machine was restarted the job never completes. It DOES get the file from the ftp site but the job itself never completes and therefore will not run again at the next scheduled time. Has anyone seen this? It was happening when I first installed winscp3, but after removing that and installing winscp (4.0.3.345) it was working - until now. Same problem.
Script is as follows:
option batch on
option confirm off
open <ftpsite>
cd <directory>
get *.txt <local folder>
exit
Script is as follows:
option batch on
option confirm off
open <ftpsite>
cd <directory>
get *.txt <local folder>
exit