Retrieving Information About an Event or Schedule

SAP Sybase IQ stores information about events, system events, and schedules in the system tables SYSEVENT, SYSEVENTTYPE, and SYSSCHEDULE.

When you alter an event using the ALTER EVENT statement, specify the event name and, optionally, the schedule name. When you trigger an event using the TRIGGER EVENT statement, specify the event name.

You can list event names by querying the SYSEVENTsytem table:

SELECT event_id, event_name FROM SYSEVENT

You can list schedule names by querying the SYSSCHEDULE system table:

SELECT event_id, sched_name FROM SYSSCHEDULE

Each event has a unique event ID. Use the event_id columns of SYSEVENT and SYSSCHEDULE to match the event to the associated schedule.