Dropping Database Triggers

Siebel administrators use the following procedure to drop database triggers.

To drop database triggers

1. Navigate to the Administration - Server Management screen, then the Jobs view.

2. Create a job for the Generate Triggers component.

3. In the Job Parameters list, define the job parameter with the values in the following table

   Name	Value
   EXEC	True
   Privileged User	<Table Owner ID>
   Privileged User Password	<Table Owner Password>
   Remove	True
   Trigger File Name	Droptrigger.sql

   Note: The values for Privileged User and Privileged User Password must be the database user name and password that have the privileges to drop and generate triggers.

4. Submit the Job and wait for it to be successful.