Monitor "Store procedure" in SQL query monitoring
In the Custom SQL Queries panel, customer has defined a query, with the "EXEC" and calling a store procedure and it works very well. The query returns only one integer value. This is put (that call a store procedure) in the Database Query related with an alarm. But in the Database Query, the return value is empty. It seems to not get the return value? So the alarm is always in error. Hence the database query put into an alarm must support the call of a stored procedure.
-Idea by Martin Bergeron.
3
votes
Praveena
shared this idea
Hi ,
Users can now manage to execute the stored procedure in a secure SQL query by enabling the option "Allow Stored Procedure Execution" in the Global Settings.
Thanks,
BizTalk360 Team