Re: Oracle 7.3 Timer for Garbarge Collection

You can use the package DBMS_JOB with the your procedure to delete rows of yours tables.

To submit (schedule):

• Submit a new job with a given job number.

  PROCEDURE submit    ( job       OUT BINARY_INTEGER,
                        what      IN  VARCHAR2,
                        next_date IN  DATE DEFAULT sysdate,
                        interval  IN  VARCHAR2 DEFAULT 'null',
                        no_parse  IN  BOOLEAN DEFAULT FALSE);

In the parameter "what" you specific the name of your procedure and interval => 'TRUNC(SYSDATE, 'HOUR') + 1'.

In the init.ora you set "job_queue_interval" and "job_queue_processes" parameters.

Regards,
Alexandre Leite.
Oracle Certified Professional

fab_lab_at_hotmail.com escreveu na mensagem <7d2vgs$f9c$1_at_nnrp1.dejanews.com>...
>Hi,
>I want to know if there is a way to set up some kind of TIMER
>( or a trigger on sysdate ??) so that EVERY HOUR I can DELETE rows in one
 of
>my tables.
>
>an example would be appreciated ...
>
>thank you very much for your help ...
>
>( can you please CC your answer directly to my Email address
>fab_lab_at_hotmail.com
>since this group is very active ;) )
>
>best Regard
>Fabrice.
>
>
>
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Mar 25 1999 - 00:00:00 CET