Developing and Deploying Siebel Business Applications > Assigning Objects and Automating Business Processes > Process of Automating a Business Process >

Running the Generate Triggers Server Component

This task is a step in Process of Automating a Business Process.

To create a database trigger, you use the Generate Trigger (GenTrig) server component on the Siebel Server. Siebel Workflow uses a database trigger to identify the records that might match a policy condition. You must run the Generate Triggers server component any time you create, modify, or delete a workflow policy.

You can run the Generate Triggers server component from the Server Manager or from the command line interface. This topic describes how to use the Server Manager. For information about using the command line interface, see Siebel System Administration Guide.

To run the Generate Triggers server component

1. Navigate to the Administration - Server Management screen, and then the Jobs view.
2. In the Jobs list, click New.
3. In the Component/Job field, click the select button.
4. In the Components/Jobs dialog box, in the Find window, choose Name.
5. In the Starting With window, enter the following text, and then click Go:

   Generate Triggers

6. In the Job Parameters list, create a new parameter for each row in the following table.

   Name	Value	Description
   Trigger File Name	trigger.sql	This file name identifies the SQL script that the Siebel Server must run. The server creates this file in the siebsrvr_root directory.
   EXEC	TRUE	If you set this parameter to TRUE, then Siebel CRM automatically runs the SQL script.
   Table Owner Password	Your password	If you use an Oracle database or an IBM DB2 database, then enter the password for the table owner.

7. In the Jobs list, click Submit Job.
8. To view updates that the Siebel Server displays in the Status field, click Query, and then click Go.

   Upon completion, the Siebel Server displays Success or Error in the Status field.

9. To view log details, do the following:
   1. Click the Tasks link.
   2. In the Tasks list, locate the job you started in Step 7.
   3. Examine the records in the Log list.