471,607 Members | 1,776 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,607 software developers and data experts.

Running a SQL server 2005 job remotely thru an AS400 program

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
0 2114

Post your reply

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

Similar topics

3 posts views Thread by Wayne Gibson | last post: by
5 posts views Thread by Nathan Given | last post: by
reply views Thread by leo001 | last post: by
reply views Thread by MichaelMortimer | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.