Sybase Adaptive Server Anywhere - Page 458

CREATE EVENT statement
440
CREATE EVENT HourlyLogBackup
SCHEDULE hourly_log_backup
BETWEEN ’8:00AM’
EVERY 1 HOURS ON (’Mon’,’Tue’,’Wed’,’Thu’,’Fri’)
HANDLER
BEGIN
BACKUP DATABASE TO ’c:\\database\\backup’
TRANSACTION LOG ONLY
TRANSACTION LOG RENAME
END
$ For more examples see "Defining trigger conditions for events" on
page 501 of the book ASA User’s Guide.