How can i use an SQL SP in a Job

avidal18 · Post by **avidal18** » Wed Apr 19, 2006 4:56 pm

I'd like to know how can i call a Stored Procedure in a job, i want to use the stage StoredProcedure, but this only have the option of uns Oracle SP, and i want to call a SQL SP, thanks for your answers.

diamondabhi · Post by **diamondabhi** » Wed Apr 19, 2006 5:10 pm

You can use SP stage in 7.5, if not you may be able to use a non-ODBC stage's Before-SQL tab to issue a CALL statement. Search the forum lot of info is present for SP.

sb_akarmarkar · Post by **sb_akarmarkar** » Thu Apr 20, 2006 6:13 am

Hi,

If there is no return from stored procedure then we can use ODBC Stage to run. Just select user defined sql and ..

Exec StoredProcedure_Name(Parm1,Parm2)

Thanks,

--Anupam

avidal18 · Post by **avidal18** » Thu Apr 20, 2006 9:09 am

Thank you, very much, finally y found the answered to my problem a head in the forum....greetings.

------------------------
Angel Martinez
Mexico