Removing a Trigger

You may need to remove a trigger if you plan to remove real-time indexing trigger from a specific transaction record. To remove an existing trigger, you should drop the trigger. However, if you drop a trigger, real-time indexing can no longer update the associated search index.

Contact your database administrator to drop a trigger.

Complete these steps to drop a trigger:

1. Open an SQL tool.

2. Run the command: DROP TRIGGER <trigger_name>;

   where <trigger_name> is the trigger that you want to drop.

   For example, DROP TRIGGER SFA_PT_PORTAL_MRU_TR;

   PeopleSoft RTI trigger names have the prefix SFA and suffix TR.