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
SQLServer stored procedure within a server job
Moderators: chulett, rschirm, roy
I absolutely agree with Ken. ODBC works better with these sorts. I do lots of these creating ODBC job to access SQL Server.
Thanks
Thanks
Regards
Siva
Listening to the Learned
"The most precious wealth is the wealth acquired by the ear Indeed, of all wealth that wealth is the crown." - Thirukural By Thiruvalluvar
Siva
Listening to the Learned
"The most precious wealth is the wealth acquired by the ear Indeed, of all wealth that wealth is the crown." - Thirukural By Thiruvalluvar