I have a table - history
with PK - id, datetime - Lastaccessed
I want to create a sybase event that will automatically delete old history which are 7 days old that will run everyday.
how will i test this if this works?
i tried to use the wizzard but it doest work when i try to change the date&time.
btw, im using sybase ADAnywhere.
can you give me a script? and to test if it works. thanx