Execute an event. You can trigger an event manually regardless of its type (manual,
scheduled, or conditional). The TRIGGER EVENT statement can be called at any time for any
event.
Prerequisites
| Database Version |
Event Privileges |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Requires DBA authority. |
| SAP Sybase IQ
16.0 |
Requires MANAGE ANY EVENT system privilege. |
- The
SAP Sybase IQ resource is authenticated and running.
- An event has been created.
Task- In the Perspective Resources view, select the resource and select .
- In the Administration Console, expand .
- Select an event from the right pane, click the arrow to the right of the name and
select Trigger.
- (Optional) Enter event parameters.
This dialog allows you to explicitly supply parameters to simulate a context for
the event handler. You can use this dialog to test trigger conditions such as disk
space restrictions (when a disk fills beyond a specified percentage) or other trigger
conditions that are required to trigger an event handler. For example, you can have
an event that takes different actions depending which user ID is connected to the
database: calling the event parameter ( 'User' ) in the event handler does this. To
simulate triggering this event for the user P_Chin, type the following in the
Parameters text box: "User"='P_Chin' The word User must be contained in double quotes
because it is a reserved word in SQL.
- Click OK to confirm trigger.