WinSCP hanging up as Scheduled SQL Job but runs fine as a Manually run SQL Job
I have a SQL Server Agent Scheduled Job that uses WinSCP to transfer sFTP files to my remote server. It does the transfer but hangs up before getting to the next task. If I stop that job that was kicked on a schedule and restart it manually, also within SQL Server Agent, it runs just fine. I have exhausted my knowledge on this one. Any help would be immensely appreciated.