Create the directory structure as follows, using your drive and path of choice:
D:\Backups
On the server, start Sybase Central.
Sign in a MT level user (Tools Connect)
Expand the database out (gray cylinder).
Click Event.
Click AddEvent.
Click on Next
Click Next
Click New.
Set hour and start date.
Select the Recurrent Tab.
Click on "Trigger on the following" and select all days of the week.
Click the OK button.
Click Next.
Insert this code into the window:
BEGIN
DECLARE day_of_week VARCHAR(9); DECLARE backup_stmt LONG VARCHAR;
SET day_of_week = substr(dayname(today()),1,3);
SET backup_stmt = 'BACKUP DATABASE DIRECTORY ' || '''D:\\BACKUPS\\' ||
day_of_week || ''' '|| 'TRANSACTION LOG TRUNCATE '; EXECUTE IMMEDIATE backup_stmt;
Change your Drive and Path accordingly. Click Next.
Click Next.
Add comments, then click Finish.
Close Sybase Central.