See https://winscp.net/eng/docs/faq_scheduler

Though first, you urgently need to upgrade. WinSCP 3.7.6 is over 15 years old!

I created a batch file to launch the WinSCP client tool "WinSCP3.com" with the credentials and transfer a csv file to the WinSCP designated folder. It works when manually execute the batch file or run it in the DOS command. However, it hangs the SQL server if I call the batch file in a SQL stored procedure. I checked the security on the tool and the folder where it transfers the file and it is not a security issue.