SQLServer stored procedure within a server job

mrlindsey · Post by **mrlindsey** » Thu Mar 23, 2006 4:25 pm

What if we are running DataStage on Unix and can't call isql or osql from the command line. Is there another way to call a SQLServer stored procedure from a server job?

-Matt Lindsey

kcbland · Post by **kcbland** » Thu Mar 23, 2006 4:36 pm

Use remsh or rsh to remote command execute on a Windoze server OSQL/ISQL.

mrlindsey · Post by **mrlindsey** » Thu Mar 23, 2006 4:41 pm

Thanks, but remote shell is not allowed at our company between servers.
-Matt

kcbland · Post by **kcbland** » Thu Mar 23, 2006 5:45 pm

You could gimmick the ODBC stage to output from an SP a dummy row after its done doing whatever you need.

rasi · Post by **rasi** » Thu Mar 23, 2006 6:59 pm

I absolutely agree with Ken. ODBC works better with these sorts. I do lots of these creating ODBC job to access SQL Server.

Thanks