Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Displays schedule information about events.
sa_event_schedules( evt_id )
This INTEGER parameter takes the ID number of an event.
This procedure returns information about a specified event, including when the event is scheduled to run and how often it
runs. If the event does not have a schedule, the procedure does not return a result set.
The following example retrieves the event schedule for the IncrementalBackup event.
call sa_event_schedules( (SELECT event_id FROM SYSEVENT WHERE event_name='IncrementalBackup') );