Developing and Deploying Siebel eBusiness Applications > Siebel Business Process Designer > Activating the Rules >

Running Generate Triggers


The Generate Trigger (GenTrig) component on the Siebel Server allows you to create database triggers. The Workflow Policies module of Siebel Business Process Designer uses these database triggers to identify which records may match policy conditions. The Generate Triggers component needs to be rerun whenever new policies are created or deleted.

You can run the Generate Triggers component from either the Server Manager graphical user interface, or command line mode. The following procedure is for the GUI. For information about running Server Manager using the command line interface see Siebel Server Administration Guide.

To generate triggers using the GUI

  1. In the Siebel Client, select View > Site Map > Server Administration >Enterprise Operation > Component Request.
  2. Click New.
  3. Select Generate Triggers from the Component Job list.
  4. This creates a new line entry but does not start the task.

  5. Click New in the Component Request Parameter list and define the following parameters:
  6. Name
    Value
    Comment
    Trigger File Name
    TRIGGER.SQL
    This filename identifies the SQL script that needs to be run. The file is created in the siebel_srvr_root directory during installation, and its contents get created as a result of generating triggers.
    EXEC
    TRUE
    Setting this parameter to TRUE causes the SQL script to be run automatically.
    Table Owner Password
    Your Password
    Password for the table owner. This is required for Oracle and IBM DB2.

  7. Click the Component Request form applet menu, and then select Submit Request.
  8. To view changes to the state, refresh the screen by clicking Run Query from the applet menu.
  9. Upon completion, the Status field contains either Success or Error.

  10. View log details by doing the following:
    1. Click the Screen Enterprise Operation.
    2. In the Show field, select Tasks.
    3. Click the view tab called Task Info Log.
    4. For more information about administering server component parameters, see Siebel Server Administration Guide.


 Developing and Deploying Siebel eBusiness Applications 
 Published: 18 April 2003