Creating an Event Schedule

Make a new schedule for an existing event.

Prerequisites
Database Version Event Schedule 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
  • ALTER 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. 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 rigth pane, select New.
    The Create Schedule Wizard appears.
  6. On the Schedule page, specify the details of the schedule.
    Option Description
    Schedule Name A unique name for the schedule
    Time The time or start and end times, in 24 h format, when the event will run.
    Date (Optional) The date on which the event will run.
  7. Click Next.
  8. 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 run.
  9. Click Finish to save changes, and exit the Create Schedule wizard.
  10. Do one of:
    • Click OK to update any changes to the database and exit the properties view.
    • Click Apply to update any changes to the database, but remain in the properties view.
    • Click Cancel to cancel any changes not updated to the database and exit the properties view.
Related tasks
Deleting an Event Schedule
Generating Event Schedule DDL Commands
Modifying Event Schedule Properties
Authenticating a Login Account for a Managed Resource