Editing an Event

Edit an event to change the parameters, permissions, or other properties.

Prerequisites 

Before you can edit an event, be sure the data server that contains the event is running, and you created and established a connection to the data server.

  1. Under the Events folder, right-click the event you want to edit, and choose Edit.

    The Event Editor opens.

  2. Edit the event properties.
    Editor Tab Description
    General
    • Change the event name in the Name field.
    • Enter an optional description in the Comment field.
    • Select Disable event handler to disable the event handler so that it does not execute when the scheduled time or triggering condition occurs.
    • From the Execution location drop-down, specify where the event is to be executed:
      • ALL: The default value. All databases execute the event.

      • CONSOLIDATED: Restricts the databases at which an event is handled.

      • REMOTE: Restricts to remote sites the databases at which an event is handled.

    • Select a trigger type:
      • Manual: This type of event handler can only be triggered manually.
      • Schedule: This type of event handler is triggered according to a time schedule.
      • Condition: This type of event handler is triggered if it satisfies a condition.
    • If you specified the trigger type as Schedule, use Add, Edit, and Delete to enter the start date, start time, and repeating behavior for the trigger.
    • If you specified the trigger type as Condition, choose a system event from the drop-down list, and specify a corresponding name, operator, value, and unit for the condition.
    Source Manually edit the SQL code for the event in the Source tab. To display line numbers for the SQL code, right-click in the left margin, and choose Show Line Numbers from the context menu.
    DDL Select this tab to view the DDL for the event. Content in this tab is not modifiable.
  3. When you are finished editing the event, choose File > Save from the main WorkSpace menu to save your changes.
Related concepts
Events
Related tasks
Creating a SQL Anywhere or Sybase IQ Event
Dropping an Event
Renaming an Event

Send your feedback on this help topic to Sybase Technical Publications: pubs@sybase.com

Your comments will be sent to the technical publications staff at Sybase, Inc. For product-related issues or technical support, contact Sybase Technical Support at 1-800-8SYBASE.