|
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 | Column constraint |
|---|---|---|
| event_id | UNSIGNED INT | NOT NULL |
| sched_name | VARCHAR(128) | NOT NULL |
| recurring | TINYINT | NOT NULL |
| start_time | TIME | NOT NULL |
| stop_time | TIME | |
| start_date | DATE | |
| days_of_week | TINYINT | |
| days_of_month | UNSIGNED INT | |
| interval_units | CHAR(10) | |
| interval_amt | INTEGER |
event_ id The unique number assigned to each event.
sched_name The name associated with the schedule for the event.
recurring (0/1) Indicates if the schedule is repeating.
start_time The schedule start time.
stop_time The schedule stop time if BETWEEN was used.
start_date The first date on which the event is scheduled to execute.
days_of_week A bit mask indicating the days of the week on which the event is scheduled:
x01 = Sunday
x02 = Monday
x04 = Tuesday
x08 = Wednesday
x10 = Thursday
x20 = Friday
x40 = Saturday
days_of_month A bit mask indicating the days of the month on which the event is scheduled. Some examples include:
x01 = first day
x02 = second day
x40000000 = 31st day
x80000000 = last day of month
interval_units The interval unit specified by EVERY:
HH = hours
NN = minutes
SS = seconds
interval_amt The period specified by EVERY.
PRIMARY KEY (event_id, sched_name)
FOREIGN KEY (event_id) references SYS.ISYSEVENT (event_id)