Re: Batch scripts?

From: Klaus Zeuch <KZeuch_at_nospamhotmail.com>
Date: 2000/07/08
Message-ID: <8k81le$lr8$17$1@news.t-online.com>#1/1

you could write a stored procedure checking for that lag and initiating emails. With dbms_job package you can submit the execution of the procedure to oracle's internal queue along with specifying rerun intervals. Sending emails can be done with utl_smtp package in 8.1.6 (pop3) or call to external procedures (using Oracle 8.xx).

Hth

Klaus
"Ben Heuer" <queerczarNOquSPAM_at_unforgettable.com.invalid> schrieb im Newsbeitrag news:1b3930e4.8b6bc65c_at_usw-ex0104-087.remarq.com...
> Hi,
>
> how do i write a batch script in oracle? i need to implement a
> reminder service where users can add an event and sign up for
> reminder, and 15 minutes before their event, i send them an
> email.
>
> how should i implement this?
>
> thansk!
>
>
> -----------------------------------------------------------
>
> Got questions? Get answers over the phone at Keen.com.
> Up to 100 minutes free!
> http://www.keen.com
>
Received on Sat Jul 08 2000 - 00:00:00 CDT