Creating an Event

Create a new event, set to be triggered manually, by a schedule or by a system event and specific conditions.

Prerequisites
Database Version Event Privileges
SAP Sybase IQ 15.3 and 15.4 You must have DBA authority.
SAP Sybase IQ 16.0 You must have one of:
  • MANAGE ANY EVENT system privilege
  • CREATE ANY OBJECT system privilege
Task
  1. In the Perspective Resources view, select the resource, and select Resource > Administration Console.
  2. In the left pane, expand IQ Servers > Compiled Objects, and then select Events.
  3. Click the arrow next to Events and select New.
    The Create Event wizard appears.
  4. On the Welcome page, specify:
    Option Description
    Resource The resource on which the event will be created.
    Name of event to create A name for the event, unique for this user.
    User The user who will own the event.
  5. Click Next.
  6. On the Event Trigger page, specify the circumstance or condition that will trigger the event:
    Option Description
    Manual Event The event will be triggered explicitly when you use the TRIGGER EVENT statement or select the Trigger menu option.
    Scheduled Event You will be able to create a schedule so that the event will execute at specified times.
    Conditional Event You will be able to specify a system event and optional trigger conditions that will trigger the event.
  7. Click Next.
  8. (Scheduled Events only) On the Schedule page, specify the details of the initial schedule. (You can create additional schedules later, through the Schedule Properties wizard).
    Option Description
    Schedule Name A name for the schedule, unique for this user.
    Time The time, or start and end time duration, in 24 h format, when the event will run (either once or the interval you specify on the Recurrence Page).
    Date (Optional) The date on which the event will first run.
  9. Click Next.
  10. (Scheduled Events only) On the Recurrence page, specify how often to trigger the event and the days to run the event:
    Option Description
    Trigger Repeatedly The recurrence interval for the event
    Specific Days The days of the week or month when the event will be triggered.
  11. Click Next.
  12. (Conditional Events only) On the Conditions page, specify condition details:
    Option Description
    System Event Select the system event which will trigger the event
    Trigger Conditions (Optional) Set one or more trigger conditions that must be satisfied, in addition to the system event, in order to trigger the event. Use the New, Edit and Delete buttons to manage the trigger conditions.
  13. Click Next.
  14. On the Options page, complete additional details for the event:
    Option Description
    Enable Event Select the checkbox to execute the event when the scheduled time, trigger condition or manual command occurs. If unchecked, the event is created, but will not run until you later enable it.
    Location Specify where the event will run:
    • Execute at all databases — Executes the event at any and all remote locations.
    • Execute at the consolidated databases only — For databases involved in SQL Remote replication, this executes the event at the consolidated database only, and not at any of the remote locations.
    • Execute at the remote databases only — For databases involved in SQL Remote replication, this executes the event at the remote database(s) only, and not at the consolidated database.
  15. Click Next.
  16. (Optional) On the Comment page, enter a comment about the event.
  17. Click Finish.
Parent topic: Events
Related concepts
Event Schedules
Related tasks
Deleting an Event
Disabling an Event
Enabling an Event
Triggering an Event
Generating Event DDL Commands
Viewing or Modifying Event Properties
Authenticating a Login Account for a Managed Resource
Related reference
Event Privilege Summary