Using the EXEC Parameter

The EXEC parameter specifies how to run the SQL script file automatically according to one of the following values:

  • TRUE. Generate Triggers automatically, creates the SQL script and applies it to your database.

  • FALSE. You must manually run the SQL script file

Set the EXEC parameter to FALSE if you want to apply the triggers manually. Reasons for applying the triggers manually are:

  • The DBA (database administrator) has not provided Siebel administrators the privilege to make schema changes, including the ability to modify or add triggers. This is very common in environments where the DBA is not directly associated with the Siebel CRM team and the DBA wants to manage database changes directly, analyzing the possible negative database performance impacts.

  • You want to add the triggers during a down time, so use EXEC=False to generate the triggers now but apply them later, for exmaple, at 2:00 AM on a Saturday night.