Bookshelf Home | Contents | Index | Search | PDF

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

Generating Triggers

---

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

From the application-level menu, choose View > Site Map > Server Components Requests > My Component Requests.
In the Component Requests list, click New.

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

In the My Components Requests form, enter the relevant information for the new component request record.
In the Components/Job field, click the select button.
In the Components/Job dialog box, query for Generate Triggers, and then click OK.
In the Server field, type the name of the Siebel Server for which you want to run Generate Triggers.
In the Request Key field, type in the name of the request key.
Complete the rest of the fields, if needed.
In the Component Request Parameters list, click New to create a new record for the Table Owner Password, and enter the relevant parameter information.
In the Name field, click the select button.
In the Job Parameters dialog box, query for TableOwnPass, and then click OK.
In the Value field, type in the password for your tableowner.

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

For the Microsoft SQL Server database, run the generated trigger.sql file against the database independently.
Select EXEC.
Click in the Value field.
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.

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

Bookshelf Home | Contents | Index | Search | PDF