The DataBee Create/Edit Trigger Manager Rule Form
When loading target subset databases with extracted data, it might be useful to disable the schema triggers prior to the load and to re-enable them again upon completion. The load process can, under certain circumstances, be considerably delayed if the there are INSERT triggers enabled on the tables being loaded as the automatic firing of the trigger for each inserted row adds considerably to the update time. In such cases, it is usually much more efficient to disable the triggers while the load operations are being performed.
The Create/Edit Trigger Manager Rule form is used to create and edit DataBee Trigger Manager rules. Trigger Manager rules are designed to manage the process of the enabling or disabling of the schema triggers. A Trigger Manager can be created in one of two modes: disable triggers or enable triggers. The mode is chosen when the rule is created and cannot be subsequently changed. The title text and button labels on the form will change as is appropriate to the enable/disable mode and also if the rule is being newly created or edited. In the example screen shot above, the form is editing an existing Disable Trigger Manager rule. The schema in which the above Trigger Manager rule is running has only one Trigger. If others were present, they would also be displayed in the list in the left hand panel.
Trigger Manager rules are only present in loader sets and a matching pair of disable and enable rules are usually created automatically by the Set Designer application when a new loader set is created. Trigger Manager rules can be created manually, if required, using the options on the New Loader Rule form.
A Trigger Manager rule is provided with the triggers known to its Rule Controller when the rule is created. To refresh the list of triggers known to the Trigger Manager rule, first refresh the triggers in the Rule Controller using the Refresh Triggers button on Options tab of the edit Rule Controller form. This retrieves an up-to-date list of triggers from the target schema. Once the Rule Controller has been updated, use the Refresh Trigger List button to refresh the list inside the Trigger Manager rule. If required, the checked or unchecked state of the triggers can be saved and then restored after the refresh using the Export Current Configuration and Import Current Configuration buttons.
The Number of Trigger Operations Permitted to Fail field configures the Trigger Manager to ignore a certain number (or all) of the errors received while processing the trigger operations. This enables the Trigger Manager to continue operating even if errors occur. Be aware that ignoring the errors in the Trigger Manager just permits the Trigger Manager to complete as many operations as possible before returning an error and stopping the execution of the masking set. In other words, even if errors are ignored, any errors which occur during the trigger disable/enable operations will mark the Trigger Manager rule as having failed and the error state will be reported to the DataBee software for handling once the actions have completed.
Important Note: Remember that the DataBee software is multi-threaded and that properly configured Rule Blocks are required to ensure the Trigger Manager rule runs in the appropriate order. Usually a disable mode Trigger Manager rule is configured with a rule block that runs it as the very first rule in the loader set and a second Trigger Manager rule is configured to run in enable mode as the very last rule.
Existing Trigger Manager rules can be edited by double clicking on them with the mouse. Trigger Manager rules are created by launching the New Trigger Manager form using the New Rule button located on the lower right hand corner of the main form in the Set Designer application.
How to Create a New Trigger Manager Rule