By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,506 Members | 1,881 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,506 IT Pros & Developers. It's quick & easy.

Running a SQL server 2005 job remotely thru an AS400 program

P: 4
We have an As400 system that has program which executes batch files which resides on the SQL server 7.0 computer . Those batch files run SQL server jobs
using isql. The whole idea about this is when ever some jobs will run on As400 to populate some files the program will be called to execute the batch files which will run the sql jobs to populate sql tables. This process working fine. But now we have installed SQL 2005 and trying to move . Before actually moving I am testing by moving one job and the batch file and creating one test As400 program that will execute that batch file. The batch file uses SQLCMD to run a job. When I try to run that batch file locally it works fine. But when I am trying to execute that batch file remotely thru the AS400 program it doesn't work. If I include some non-sql command in that batch file and execute that batch file remotely it runs those commands but does n't execute the sql commands.
The user_id and password the remote command uses has all the appropriate rights. Also I changed the settings of the sql server (as per the msn guide) to accept remote commands. still it does n't work. Can any one please suggest something ? Thanks in advance for your help..
Oct 18 '06 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.