Re: How to automate a procedure?

From: Power User <david.swanson_at_sprintranet.com>
Date: Sat, 12 Dec 1998 00:58:26 GMT
Message-ID: <3673bf74.175380375@nntp.sprintisp.com>

Oracle has a package called DBMS_JOB that you would need to use to do this... I would look in Oracle's documentation for DBMS_JOB, there are several steps to have this work including setting various database parameters (job_queue_process and job_queue_interval)...

On 12 Dec 98 00:39:23 GMT, dolans_at_stripe.Colorado.EDU (Sean Dolan) wrote:

> I am new to the world of Oracle, so please bear with me. But if I wanted to have a procedure run every hour on the hour (to check the time left untouched of certain records to then be sent to another indivdual), how would you "automate" the hourly function? Triggers? And how is that done? Any pointers to chapters in books would be great.
>
>Thanks for your help,
>Sean
>
>PS Respond to sean_at_3si.com if you could. Thanks again!
Received on Fri Dec 11 1998 - 18:58:26 CST