I am having issues automating a batch file using the windows task scheduler. The worst part is this process was working for years, and now it does not.
Background.
I am transferring files to a 3rd party vendor via SSH2 using psftp.exe. I have a batch file that performs the following process:
1. runs ftp command to get the data from my Unix server.
2. copies the files to a location on the windows server and renames them.
3. launches psftp.exe from the directory where these files are stored.
4. put commands to place them on the 3rd party server.
5. deletes the files from the window directory.
If I run this batch file manually, the process works flaulessly. When I try and schedule this through Windows task scheduler, it is failing at between step 3 and 4.
The issue started last week when the 3rd party vendor changed SSH servers. I updated the batch file with the new information, but then started to experience the issue above.
Any help will be greatly appreciated.
Thanks,
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Please see below: This is a copy of the script that I am running.
ftp -s:d:\televoxupload\thursd
copy d:\televoxupload\televox d:\televoxupload\appt.dat
copy d:\televoxupload\housecall
copy d:\televoxupload\mastrosat
psftp.exe sshserver.com -l sportzzphann -pw Ph1ll135 -b uploadcommands.txt
del televox
del appt.dat
del housecallh
del hcalls.dat
del mastrosat
del Mhc.dat
Sorry but I was away from my computer.
Try to put the full path to the command:
"c:\program files\putty\"psftp.exe sshserver.com -l sportzzphann -pw Ph1ll135 -b uploadcommands.txt
Please don't post real username and password
I didn't give you real user information.
I have tried what you have suggested, the psftp.exe process is launching. I can see it in my task manager, but I can't actually see the application on the screen and it the process just sits there. The scheduler says it is running, but nothing is occurring. The files are showing pulling from the Unix server and sitting in the \\televoxupload\ directory.
If I manually kill the psftp.exe process, it continues to run the batch file and the file are deleted from the directory. Unfortunately, they were never transferred to the 3rd party vendor.
I have tried changing the account which is running the scheduled task, but with no success.
FYI
The psftp.exe is located in the same directory as the batch file. This is why I didn't have the full path inclucded in the script. I don't think it is necessary, but I am still learning this stuff, so I gave your idea shot.
Thanks
I GOT IT!!!!
Thanks for helping to talk me through this. Sometimes just talking out with someone leads you to places you should have gone before.
Issue was that I was logged into the server as myself. So, when I ran the batch file manually and it asked me store the certificate for the SSH2 server in the psftp app, it stored it for my profile. Unfortunately, when the task scheduler was running the scheduled task, it was running it under a different profile.
Thus, I simply needed to log into the server under the profile that is running the scheduled tasks, launch the batch file manually, and accept the SSH2 server certificate for that profile. Now the task scheduler is able to run the tasks as well.
Business Accounts
Answer for Membership
by: omarfaridPosted on 2008-05-22 at 08:57:19ID: 21625008
how do you pass password ? can you post script ?