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.
SAP Sybase IQ 16.0 None.
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. Select an event from the right pane and either:
    • Click the arrow to the right of the name and select Properties, or
    • From the Administration Console menu bar, select Resource > Properties
    The Event Properties view appears.
  4. In the left pane, select Schedules.
  5. In the right pane, select one or more schedules, and select Generate DDL.
    Tip: Use Shift-click or Control-click to select multiple schedules.
    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