Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » Views » System views in Sybase Central

SYSREMOTEUSER system view Next Page

SYSSCHEDULE system view

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
sched_name VARCHAR(128) 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:

days_of_month    A bit mask indicating the days of the month on which the event is scheduled. Some examples include:

interval_units    The interval unit specified by EVERY:

interval_amt    The period specified by EVERY.

Constraints on underlying system table

PRIMARY KEY (event_id, sched_name)

FOREIGN KEY (event_id) references SYS.ISYSEVENT (event_id)