Each row in the SYSSCHEDULE system view describes a time at which an event is to fire, as specified by the SCHEDULE clause of CREATE EVENT. The underlying system table for this view is ISYSSCHEDULE.
|Column name||Data type||Description|
|event_id||UNSIGNED INT||The unique number assigned to each event.|
|sched_name||VARCHAR(128)||The name associated with the schedule for the event.|
|recurring||TINYINT||Indicates if the schedule is repeating.|
|start_time||TIME||The schedule start time.|
|stop_time||TIME||The schedule stop time if BETWEEN was used.|
|start_date||DATE||The first date on which the event is scheduled to execute.|
A bit mask indicating the days of the week on which the event is scheduled:
A bit mask indicating the days of the month on which the event is scheduled. Some examples include:
The interval unit specified by EVERY:
|interval_amt||INTEGER||The period specified by EVERY.|
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|