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 |