Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: server date functions ?

Re: server date functions ?

From: Rudy Zung <zungr_at_prograph-inc.com>
Date: Mon, 22 Mar 1999 17:39:31 -0500
Message-ID: <7d6gpv$7ls$1@mailhost.prograph-inc.com>


Oracle provides a package that schedules things to be run at a specific time.
I think the package name is DBMS_JOBS, or something like that.

...Ru

m.n.nedermeijer_at_rtd.nl wrote in message <7d6b77$94u$1_at_nnrp1.dejanews.com>...
>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 - 16:39:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US