Skip to Content
Nov 29, 2017 at 04:11 PM

How to use a stored procedure in a switch task IDM8 ?


I am using microsoft sql server as database. I created the procedure "mxpt_<procedure_name>" with the *_oper user in the DB. It is still not seen by the switch task. I tried to grant the procedure the "_rt" user but it didn't work. it returns 'Cannot find the object 'mxpt_<procedure_name>', because it does not exist or you do not have permission.'

Can anyone please explaine to me how to create correctly a stored procedure that can be seen by a conditional task ?

Thank you