By scheduling activities you can ensure that a set of actions is executed at a set of preset times. The scheduling information and the event handler are both stored in the database itself.
See”Understanding schedules” in SQL Anywhere Server - SQL Usage.
For examples, use the Sybase IQ demo database iqdemo.db.
For installation information, see “The demo database”.
Create table OrderSummary(c1 date, c2 int);create event Summarizeschedulestart time '6:00 pm'on ('Mon', 'Tue', 'Wed', 'Thu', 'Fri')handlerbegin insert into DBA.OrderSummary select max(OrderDate), count(*) from GROUPO.SalesOrders where OrderDate = current dateend
