calling two sql server jobs with the batch file and passing different files to upload its not working
which every job runs first uploads the file correctly the other jobs just runs and completes.
Below is the job script.
rem generate temporary script to upload %1
echo open SFTP://firstname.lastname@example.org:1234/ -privatekey=c:\privatekey.ppk>>script.tmp
echo put -resumesuppport=off %1 /outputfolder/>> script.tmp
rem Execuit Script
winscp.com /ini=null /script = script.tmp
rem delete temporary script