==== 3.4.3. Enable the Notification Listener stored procedure ====

After configuring the SB1 Notification Listener, the stored procedures must be enabled in the “PMX_TransactionNotification” SAP stored procedure as follows.

Note: If the SB1 Notification Listener is not installed, continue with section [[implementation:wms:install_registeraddon|3.5. Register the Produmex add-on]].

===With Microsoft SQL Server===

1. Open the SQL Server Management Studio and connect to your database server.

2. Expand the //Databases// folder and locate the company database to which you want to apply the Produmex Add-on.

3. Open this database directory and open the Programmability / Stored Procedures subdirectory.

4. Locate the dbo.PMX_SP_TransactionNotificationQueue stored procedure, right-click it and select //Modify//. 

{{ :implementation:install:installguide:notification_listener_stored_procedure_01.png?nolink |Enable the Notification Listener stored procedure}}

5. Locate the //Produmex SboNotification Queue Code// at the end of this stored procedure (see illustration below).

{{ :implementation:wms:sql1.png |code}}

6. Copy the //Produmex SboNotification Queue Code//.\\

This code should now be pasted in the “dbo.PMX_SP_TransactionNotification” stored procedure in the **Company database** as follows.

7. Locate the “dbo.PMX_SP_TransactionNotification” stored procedure, right-click it and select ''Modify''.

{{ :implementation:install:installguide:notification_listener_stored_procedure_03.png?nolink |Enable the Notification Listener stored procedure}}

8. Paste the “Produmex SboNotification Queue Code” at the end of it, right after the code you have copied for the Produmex Addon stored procedure (see 3.3.1. Enable the standard PMX stored procedure).

{{:implementation:notification_listener_stored_procedure_04.png?nolink|Enable the Notification Listener stored procedure}}

9. Uncomment the SP by clicking the ''Uncomment'' button in SQL Management Studio.\\
The result should look like this:

{{:implementation:notification_listener_stored_procedure_05.png?nolink|Enable the Notification Listener stored procedure}}

10. Execute the PMX_SP_TransactionNotification stored procedure.

===With SAP HANA===

1. Open the SAP HANA Studio and connect to your SAP HANA server.

2. Locate the PMX_SP_TransactionNotificationQueue stored procedure, right-click it and select ''Open Definition''.

{{ :implementation:wms:hana6.png |PMX_SP_TransactionNotificationQueue stored procedure}}

3. Open its content by opening the Create Statement tab.

4. Locate and copy the Produmex SboNotification Queue Code at the end of this stored procedure. This code should now be pasted in the PMX_SP_TransactionNotification stored procedure.

{{ :implementation:wms:hana2.png |PMX_SP_TransactionNotificationQueue stored procedure}}

5. Locate the PMX_SP_TransactionNotification stored procedure, right-click it and select ''Open Definition''.

{{ :implementation:wms:hana3.png |PMX_SP_TransactionNotification stored procedure}}

6. Open its content by opening the Create Statement tab.

7. Paste the Produmex SboNotification Queue Code at the end of it.

8. Uncomment the copied code by removing the leading '–' from each line.

9. Execute the code.

{{ :implementation:wms:hana4.png |Paste the Produmex SboNotification Queue Code}}