Good afternoon,

I need to daisy chain a SQL Server job with an AS400 job (have the AS400 job kick off the SQL Server job). I've been told that this can be done but how do I do this? What connectivity do I need and more pressing right now, what is the command line syntax for such a job?

thanks,

Bob

Thanks Adam... I had to tweak it just a bit but it works. One further question... when I run this from a command prompt, after it starts, there is a message that the command "started successfully." Then the next line looks like this...

1>

If I press the enter key it simply adds a >2 below that.

Does this mean the system is waiting on something to get me back to a regular command prompt?

Thanks again,

Bob

Adam, I figured it out... in your example change the small q to a captial Q

Thanks again, Bob

I got this to work using the sa account but not when I run it with a SQL Server account. I gave rights to the SQL Server account to execute the stored procedure as well as the sp_start_job stored procedure.

Any ideas how I can get a generic SQL Server account to work?

Thanks,

Bob