Re: Send e-mail after job has finished

playmaker_at_iname.com (Playmaker) wrote in message news:<459dd057.0304040343.efd66a0_at_posting.google.com>...
> Hi everybody.
> Does anyone know of a simple way using Oracle 7.3.4 to notify a single
> user when snapshot process has been completed (sent out as jobs)? The
> job is submited to an oracle database (on Unix) through a form. I
> would like to get a mail when the job either finishes successfuly, or
> when it breaks.
>
> This job calls a database package, which means that sending an e-mail
> through the package just before it finishes,would be an option(correct
> me if I am wrong). But again how can this be done?
> Any advice would be valuable.
> Thank you in advance.
> Best Regards.

I used to have a sample of code the author said would send an email from Oracle but I could not find it. What I did find was a whole slew of posts on the subject using the advanced search feature at http://groups.google.com on the subject. For a 7.3 solution you might want to try looking through the posts one of which by Connor McDonald reference Oracle document # Note:47498.1 from 1997 on the subject.

HTH -- Mark D Powell -- Received on Fri Apr 04 2003 - 16:54:17 CEST