I already asked this question before but did not get any reply. Anybody please help..
I am calling a job on AS400 which uses RUNRMTCMD to execute a batch file on sqlserver 2005 server. This batch file uses sqlcmd command to run a job on sqlserver. When I execute this batch file manually from this sql server computer it works fine. But when I am trying to run it thru the AS400 job it doesn't work. When I created a test batch file which runs thru the AS400 job but doesn't use the sqlcmd command and tried to run that batch file from the sql server computer thru calling the AS400 job that works fine.The remote login used in the AS400 program has all the administrative rights and I tried tp logon as this login and try to execute that batch file locally , it works fine. Please help. Thanks in advance.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!