Check stored procedure output parameter and send mail if

One Star

Check stored procedure output parameter and send mail if

I call a SQLServer stored procedure that return a value using output parameter
I would like to send an email if it returns 1 using "if" connector.
I don't know what condition to put in the connector IF
Can you help me ?
One Star

Re: Check stored procedure output parameter and send mail if

Hi
Save the return value into a context variable(e.g context.flag).
Set condition as follow.
context.flag ==1

Regards,
Pedro