Friday, January 11, 2013

How to Drop and Regenerate Triggers

To drop trigger:

1. Navigate to Application - Server Management > Jobs
2. Create a new job with Component / Job as 'Generate Triggers' with the below Parameters

Privileged User - SADMIN
Privileged User Password - SADMIN User's Password
EXEC - TRUE
Remove - TRUE

To Regenerate Trigger:

1. Navigate to Application - Server Management > Jobs
2. Create a new job with Component / Job as 'Generate Triggers' with the below Parameters

Privileged User - SADMIN
Privileged User Password - SADMIN User's Password
EXEC - TRUE
Remove - TRUE

No comments:

Post a Comment