To find an existing trigger:Use the Dynamic Trigger Definition window to:
Find a trigger that already exists. Existing triggers are referred to as static triggers.
Create a new trigger. Any new triggers that you create are referred to as dynamically generated triggers.
Enable and disable triggers.
Note: If you are using a third party payroll product do not use this window. Use the Dynamic Trigger Functional Area Grouping window to enable business groups and their associated triggers.
To find an existing trigger:Select either Dynamically Generated Triggers or Static Database Triggers.
Select an Application to restrict the range of your search. Note that this does not refer to the application owning the trigger. It refers to the application owning the table to which the trigger is applied.
Enter one of the following:
A table name.
A trigger name.
A table name and a trigger name.
Select a Triggering Action or a combination of triggering actions.
Select the Trigger Type (static database triggers only).
All - displays all existing triggers
Before Each Row
Before Each Event
After Each Row
After Each Event
Instead of Each Row
Instead of Each Event
Statement
Note: These criteria do not apply to triggers created dynamically. Dynamic triggers are always defined to run after each row.
To enable and disable dynamic triggers:Warning: These instructions apply to dynamic database triggers only. You should never disable a static database trigger.
When you have found the database trigger corresponding to your search criteria, you can see whether the trigger is enabled or disabled. The Enabled flag is checked if the trigger is enabled, and unchecked if the trigger is disabled.
You can change the status of the trigger by checking or unchecking the Enabled flag.
Changes become effective immediately.
To create a dynamic trigger:Select Dynamic Database Triggers.
Enter a description for the trigger. This description will appear as a comment in the generated code.
Select the table on which this trigger operates.
Select the action type for the trigger:
Insert - the trigger may be created after Insert.
Update - the trigger may be created after Update.
Delete - the trigger may be created after Delete.
Dynamic trigger creation does not support:
The combination of insert, update and delete actions available when creating static triggers.
Triggers that are not of the after each row type.
Save the trigger definition.
When you have saved the trigger definition you cannot change the table on which a trigger is run, nor can you change the action that the trigger performs. Instead, you must delete the trigger and then recreate it with the correct details.