Bookshelf Home | Contents | Index | PDF |
Siebel Business Process Designer Administration Guide > Workflow Policies > About Workflow Policies Server Administration > Running the SQL Script FileOnce Generate Triggers has completed, run the SQL script file if the EXEC parameter is FALSE.
For example, the policy administrator, Bill Stevens, has finished creating policies in the test Siebel Client and wants the database triggers set in the Siebel database for the new policies. Using the Generate Triggers component, he sets the file output name. This creates a file, TRIGGER.SQL, for the database administrator containing all the triggers that need to be modified or created in the test database for these policies. The database administrator then runs the following command in SQL*Plus to create the triggers in the Oracle database: The successful creation of each database trigger in the Oracle database is indicated on the screen. For information on the syntax required for other databases, refer to your database documentation. NOTE: On an MS SQL server database, execute the script trigger.sql as the database owner (dbo) login for the Siebel database. |
Siebel Business Process Designer Administration Guide |