Re: server date actions ?

From: Christopher M. Day <christopher.day_at_rdbms.freeserve.co.uk>
Date: Mon, 22 Mar 1999 21:51:10 +0000
Message-ID: <36F6BB4E.F4B16CB7@rdbms.freeserve.co.uk>

Marco,

Why not write a stored procedure that is submitted via DBMS_JOB package to do this, at least this way the code will be contained in the database, and could be executed at whatever interval you like.

Chris.

m.n.nedermeijer_at_rtd.nl wrote:
>
> Hello,
>
> Is it possible to execute triggers or procedures on their own ?
>
> I want to clean up records from my database at a certain date. Some records
> may last for a few days, others for a few weeks depending on whatkind of
> information they have.
>
> Is something possible or should i write a client-based program which i must
> run every day ?
>
> Thanks,
>
> marco Nedermeijer
> m.n.nedermeijer_at_rtd.nl
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Mon Mar 22 1999 - 15:51:10 CST