calling Winscp batchfile in sql server 2008 jobs parallely not working
Calling batch file in one sql server job and it works fine but
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://xxxx@xx.com: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
del script.tmp
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://xxxx@xx.com: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
del script.tmp