How to Deactivate System Triggers

Description

Some system triggers have their own global setting (e.g. Notify All Deal Members About Assigned Document / Email / Journal). But most of them cannot be disabled using admin interface, so they need to be disabled in the database.

Version

All versions of eWay-CRM

Difficulty

High

Resolution

For example, notification about a change of the project owner can be turned off using the following script that is executed on the eWay-CRM server database. Please include a note with the reason of deactivation.

EXEC eWaySP_SuspendTrigger 'eWaySP_Projects_OwnerChangedNotifier', 'Customer does not want to receive this notification see ticket XYZ for details.'

After the query is executed WebService needs to be restarted to apply the changes.