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||Column 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.|
|days_of_week||TINYINT||A bit mask indicating the days of the week on which the event is scheduled:
|days_of_month||UNSIGNED INT||A bit mask indicating the days of the month on which the event is scheduled. Some examples include:
|interval_units||CHAR(10)||The interval unit specified by EVERY:
|interval_amt||INTEGER||The period specified by EVERY.|
PRIMARY KEY (event_id, sched_name)
FOREIGN KEY (event_id) references SYS.ISYSEVENT (event_id)
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|