DSXchange

I need to do something similar.
Where in the job would you put the IsValid() function so that the job will fail if the function fails?

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

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

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