Showing posts with label Server Administration. Show all posts
Showing posts with label Server Administration. Show all posts

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