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

x

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

Medium Priority
1,018 Views
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.
Comment
Watch Question

Aaron TomoskyDirector, SD-WAN Solutions
CERTIFIED EXPERT

Commented:
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

Author

Commented:
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.

Commented:
Maybe we could improve the batch file they use to resolve this 1 minute limmitation.
VP Technology / Senior Consultant
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
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.

OR

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.