Generating Database Triggers

Siebel administrators use the following procedure to generate database triggers.

To generate 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 a job with the values in the following table.

    Name Value

    EXEC

    True

    Privileged User

    <Table Owner ID>

    Privileged User Password

    <Table Owner Password>

    Trigger File Name

    Gentrigger.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.