Siebel Assignment Manager Administration Guide > Running Assignment Manager > Process of Running Dynamic Assignment >

Generating Triggers for Dynamic Assignment Using the UI

Use the Generate Triggers server 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 server component.

For 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

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.

To generate triggers for dynamic assignment using the UI

1. Navigate to the Administration - Server Management screen > 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 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. In the My Component Requests form, click the Menu button, and then click Submit request.

For more information generating database triggers, see Siebel Business Process Designer Administration Guide.