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

    MS22116

    Privileged User Password

    (No example)

    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. The user name value in this table is an example.
  4. Start the job.