Generating Event Schedule DDL Commands

Display the SQL data description language for creating a new schedule for a selected event. The SQL code can be a useful reference and training tool.

Prerequisites
Database Version Event Schedule Privileges
SAP Sybase IQ 15.3 and 15.4 None required.
SAP Sybase IQ 16.0 None required.
Task
  1. In the Perspective Resources view, select the resource and select Resource > Administration Console.
  2. In the Administration Console, expand IQ Servers > Compiled Objects > Events.
  3. Select an event from the right pane, click the arrow to the right of the name and select Properties.
    The Event Properties view appears.
  4. Select the Schedules area.
  5. Select a previously created schedule for the event, and select Generate DDL.
    The DDL view opens, showing the SQL code used to create the selected event schedule.
Related tasks
Creating an Event Schedule
Deleting an Event Schedule
Modifying Event Schedule Properties
Authenticating a Login Account for a Managed Resource