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.