Bookshelf Home | Contents | Index | Search | PDF |
Siebel Business Process Designer Administration Guide for Financial Services > Workflow Policies Server Administration > Creating Database Triggers >
Running Generate Triggers
When running Generate Triggers, remember the following tips, especially if you are deleting a policy:
- Deleting a policy and then running Generate Triggers does not remove the database trigger. When you delete a policy, you must run Generate Triggers with the remove parameter set to TRUE. This removes all triggers. You must then rerun Generate Triggers to reset the triggers for existing policies.
- You need to stop and restart the Workflow Monitor Agents when running Generate Triggers.
- Generate Triggers needs to be rerun whenever you change policy conditions. Generate Triggers does not need to be rerun when changing policy actions.
- For SQL Server, you should have your default database set correctly. To determine your default database, launch the SQL Server Enterprise Manager and navigate to the SQL Server Machine name. Then, click Security and then click LOGIN. The default database will be listed to the right.
To generate triggers using the GUI
- In the Siebel Client, select View > Site Map > Server Administration > Enterprise Operations > Component Requests.
- Click New.
- Select Generate Triggers from the Component Job list. This creates a new line entry but does not start the task.
- Click New in the Component Request Parameter Applet to modify parameter settings. The component-specific parameters for Generate Triggers are in Table 81. See Siebel Server Administration Guide for a description of the generic and enterprise parameters.
- Enter your Privileged User name and password.
- Click the Component Request form applet menu, then select Submit Request.
- To view changes to the state, refresh the screen by clicking Run Query from the applet menu.
- Upon completion, the Status field contains either Success or Error. It is recommended that you view the log details. To do this, click Screen Enterprise Operations. In the Show field, select Tasks, then click the view tab called Task Info Log.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Business Process Designer Administration Guide for Financial Services Published: 22 May 2003 |