- Edit or create a ruleset.
- From the ruleset toolbar, click Workloads.
- Select or create a workload.
- Click the Exceptions tab.
- Next to Exceptions, click
. - Enter a name.
- [Optional] Enter a description.
- Under Criteria, select an option from the list, click , and specify the additional required information.You can select and add multiple criteria. If you do so, all criteria must be satisfied for the exception to be triggered.
- For qualified criteria marked with *, enter a value in the Qualification Time box.
- Under Actions, select one of the following actions to be performed when the specified criteria are met:
Action Description Notification Only Sends notification and takes no other action. Abort Stops the query. Abort Selects Only Stops the query only if it is a SELECT. Change Workload to Changes the query to the workload you select from the list. This action is unavailable for Blocked Time or Elapsed Time.
- [Optional] Under Notifications, enable any of the following options for the start or the end of the event:
Notification Description Notify Database User Sends an email alert to database user when the query stops. This option is available if you have selected only Abort/Abort Selects from actions. Send Alert Specifies the action to trigger. Run Program Specifies the Alerts registered programs to trigger. Post to QTable The string you enter is posted to the QTable. - Click OK.