Hi M.F.
Thank you for your help last time.
This time could you help me with the calling SP from data manager. It is executed in sql server but when i am using SP node in data manager it is not executed. please find the pic attached. thanks
Quote from: jkabir on 06 Sep 2019 12:50:07 PM
Hi M.F.
Thank you for your help last time.
This time could you help me with the calling SP from data manager. It is executed in sql server but when i am using SP node in data manager it is not executed. please find the pic attached. thanks
Hi,
I think you have misinterpreted what a Procedure Node is used for in Data Manager. It is there to allow you to define procedural code within a jobstream, not specifically to call a database stored procedure. Your easiest option is to use a SQL Node instead of a Procedure Node and call your stored procedure from within that. If you really do need to use Procedure node for reasons not mentioned in this post, you can also do this, but your SP call would need to be encapsulated within a sql() function.
Cheers!
MF.