Re: E-Mailing from Oracle / Solaris?

From: Venkat <vreddy_at_no_spamix.netcom.com>
Date: Sun, 19 Jul 1998 13:28:19 -0400
Message-ID: <6otaa0$ajp@sjx-ixn6.ix.netcom.com>

If you have access to Oracle Enterprise Manager (windows NT/95) it is very easy to send a mail/page on certain database events. We are running Oracle 8.0.4 on Solaris 2.6 and I have OEM setup to send a page. In fact OEM has a few built in events like database up/down, listener up/down etc. The optional performance pack has a lot more events though. If you know how to write the rather arcane TCL you can write your own events.

Good luck

Venkat

>I'm using Oracle 8.0.4.0.0 under Solaris 2.6
>
>I need to be able to set up a trigger or similar system whereby upon a
>certain event taking place, Oracle sends an E-Mail. I cannot use a
>Solaris cron job as the E-Mail needs to be sent upon a certain event
>rather than at a set interval.
>
>If anybody knows of any plugins, procedures, methods etc for doing
>this I would be extremely grateful for information.
>
>Please CC replies to russ_at_u-net.net if possible.
>
>Regards,
>Russell Fray.
>
Received on Sun Jul 19 1998 - 12:28:19 CDT