If you have stored procedures that you set up in the eventNotifications section of the configuration, then this section is used to configure them.


Lets say that your eventNotifications config looked like this:




You have declared that you want to execute a stored procedure called Log_Event.  You now need to add a configuration for this procedure.  Your storedProcedures section might end up looking like this:



Lets go through each piece involved.  The storedProcedure element defines 1 stored procedure.  Each stored procedure that you will use requires its own storedProcedure element and they should all be contained inside the single storedProcedures element.  Inside each storedProcedure element is a collection of parameter elements.  There can be as many parameter elements as you want or even 0.  Each parameter element defines a single parameter in your stored procedure.


The attributes that you want to configure for each element are as follows:


storedProcedure:

  • name:  This is the name of the stored procedure.

parameter:
  • name:  This is the name of the parameter.
  • dataType:  This is the SQL data type of your parameter.
  • length:  Optional.  This is the length of your parameter, if the SQL data type is a string.
  • source:  This is the name of the event property that you want to use as the parameter's value.  For a full list of available properties, click here.