Generating Triggers for Dynamic Assignment Using the GUI

Use the Generate Triggers component to generate the database triggers used by Workflow Manager to detect changes in the database.

Note: You cannot create custom triggers on the Siebel database. The only supported triggers allowed on the Siebel database are those generated during installation or from running the Generate Triggers component.

For dynamic assignment, you must run the Generate Triggers component after:

• Creating or changing an Assignment Object, Assignment Attribute, or Assignment Criteria object type in Siebel Tools

• Changing assignment policies

• Installing or upgrading the Siebel Server

  Tip: When amending an assignment rule, criteria, or value, or when making changes to assignment positions in dynamic mode, you do not have to drop and regenerate database triggers.

Complete the steps in the following procedure to generate triggers for dynamic assignment using the GUI. This task is a step in the Process of Running Dynamic Assignment.

To generate triggers for dynamic assignment using the GUI

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

2. In the Jobs list, click New.

   A new record appears with a system-defined ID automatically generated with a status of Creating.

3. In the Job Detail subview, enter the relevant information for the new component job record.

   1. In the Requested Server field, type the name of the Siebel Server for which you want to run Generate Triggers.

   2. In the Request Key field, enter the name of the request key.

   3. Complete the rest of the fields, if needed.

4. In the Job Parameters list, click New to create a new record for the Privileged User, and enter the relevant parameter information.

   1. In the Name field, click the select button.

   2. In the Job Parameters dialog box, query for PrivUser, and then click OK.

   3. In the Value field, enter the privileged user name.

      Note: If you are using a Microsoft SQL Server database, then you must set the Privileged User Password value to the user password with tableowner privileges. Also make sure that the Table Owner value is set to dbo.

5. In the Job Parameters list, click New to create a new record for the Privileged User Password, and enter the relevant parameter information.

   1. In the Name field, click the select button.

   2. In the Job Parameters dialog box, query for PrivUserPass, and then click OK.

   3. In the Value field, enter the privileged user password.

6. In the Jobs List, click the Start button.

For more information about generating database triggers, see Siebel Business Process Framework: Workflow Guide.