<div>
delete MyTable<br />
where datediff( day, last_accessed, getdate() ) &gt;&nbsp;7<br />
<br />
or <br />
<br />
delete MyTable<br />
where dateadd( day, 7, last_accessed ) &lt;&nbsp;getdate() <br />
<br />
HTH<br />
<br />
Namasi Navaretnam<br />
<br />

</div>


delete MyTable
where datediff( day, last_accessed, getdate() ) > 7

or

delete MyTable
where dateadd( day, 7, last_accessed ) < getdate()

HTH

Namasi Navaretnam



<div>
i mean <br />
howto, <br />
create event eventname as {<br />
everyday at 01:00<br />
<br />
delete MyTable<br />
where dateadd( day, 7, last_accessed ) &lt;&nbsp;getdate() <br />
}
</div>


i mean
howto,
create event eventname as {
everyday at 01:00

delete MyTable
where dateadd( day, 7, last_accessed ) < getdate()
}

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


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

How to create a schedule?

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.