Siebel Assignment Manager Administration Guide > Running Assignment Manager > Running Assignment Manager in Dynamic Mode >

Generating Triggers for Dynamic Assignment

To run dynamic assignment, you need to run the Generate Triggers server 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

NOTE:  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 then regenerate database triggers.

Use the Generate Triggers server component to generate the database triggers used by Workflow Manager to detect changes in the database. For more information about starting and using Generate Triggers, see Siebel Business Process Designer Administration Guide.

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 server component.

To run Generate Triggers

1. From the application-level menu, choose Navigate > Site Map > Administration - Server Management > Jobs.
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 request 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, type in 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, type in the privileged user name.

      NOTE:  If you are using a Microsoft SQL Server database, you need to 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, type in the privileged user password.
6. For the Microsoft SQL Server database, run the generated trigger.sql file against the database independently.
   1. Select EXEC.
   2. Click in the Value field.
   3. Type FALSE.

      NOTE:  If the EXEC parameter is set to TRUE, the Generate Trigger component automatically creates the SQL script and applies it to the server database.
      
      Also, if you are creating a large number of triggers because there are too many workflow policies, the triggers should be applied by the user and not by the Generate Triggers server process. The EXEC parameter should be set to FALSE in this case.

      For more information on the EXEC parameter, see Siebel Business Process Designer Administration Guide.

7. In the My Component Requests form, click the Menu button, and then click Submit request.