We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now


How to launch .exe pgm from within FTP to MS SQL server to proces uploaded files

Medium Priority
Last Modified: 2013-12-09
I have a client that we are transferring order files to a MS SQL Server from IBM iSeries using FTP
Once the file transfers have completed, the client wants us to run a pgm that will process the uploaded files.
I have been unable to make the QUOTE cmd in FTP run the remote cmd. I have been reluctant to look at using
RUNRMTCMD since it opens up the Host system to incoming remote cmds.

The clients' vendor has suggested running an HTTP cmd but not sure how to launch that via FTP or
from within my CL pgm.

Any suggestions would be greatly appreciated.
Watch Question

Aaron TomoskyDirector, SD-WAN Solutions

You could make a batch file that checks the FTP folder and runs the command if the file is there. Schedule that to run every few min


They are using that method currently and they can't set the time between checks to be less than 1 miinute so that won't work which is why I am looking for a way to launch the .bat or .exe to run after I have uploaded my files.

Maybe we could improve the batch file they use to resolve this 1 minute limmitation.
VP Technology / Senior Consultant
Unlock this solution and get a sample of our free trial.
(No credit card required)
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.