Modifying Event Schedule Properties

Edit the properties of a schedule for a selected event.

Prerequisites
Database Version Event Schedule Privileges
SAP Sybase IQ 15.3 and 15.4

View any event schedule property page – none.

Modify any event schedule property – you must have DBA authority.
SAP Sybase IQ 16.0

View any event schedule property page – none.

Modify any event schedule property – 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 right pane, select a schedule, and select Edit.
    The Schedule Properties view appears.
  6. View or modify the properties.
    Area Description
    General Displays the values specified when the schedule was created. Editable fields are:

    Start Time – The time, or start and end times, in 24 h format, when the event will run.

    Start Date – (Optional) The date on which the event will run.
    Recurrence

    Trigger Repeatedly – The recurrence interval for the event.

    Specific Days – The days of the week or month when the event will run.
  7. Click OK to save changes, and exit the Schedule Properties view.
  8. 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.
Parent topic: Event Schedules
Related tasks
Creating an Event Schedule
Deleting an Event Schedule
Generating Event Schedule DDL Commands
Authenticating a Login Account for a Managed Resource