Re: Email/Page Notification using Oracle8i
Date: 1999/10/24
Message-ID: <fRKQ3.24415$up3.33545_at_news21.bellglobal.com>#1/1
I have once done this kind of system ,
Let me tell you How I did it..
I first had to find a program that can E-Mail from the DOS prompt :
- Postie (you can find it at Download.com)
After, I did a Forms program that monitors the critical information, example
That's it !
If Oracle has a problem, to get E-Mailed of paged etc..
with a Timer (every hour for instance) and if a Tablespace is used at 85%
(or more),
I sent myself an E-Mail with the Forms HOST command ..
I don't think that Oracle 8i has an integrated system that can do something similar...
Patrick Hamou
Michael Chan <MikeChan_at_pacbell.net> wrote in message
news:hgKQ3.150$4R2.18858_at_typhoon-sf.snfc21.pbi.net...
Oracle DBA
patrickhamou_at_hotmail.com
> built ins for doing notification.
>
> I want to have a monitor that can page or email me in case of any database
> failures.
>
> Also, I'd like to be able to program in PL/SQL some sort of alert system.
> The system would allow users to
> register for a certain event to occur for example, if Madonna was playing
a
> concert. If I insert data indicating
> that Madonna was playing, the system would look up all users that have
> registered an interest in the artist and send out
> a mass email.
>
> Does Oracle8i have any sort of built in notification like this that can
> interface with email and paging? I have heard of Oracle Intelligent
Agent.
> Would this component do what I want?
>
>
Received on Sun Oct 24 1999 - 00:00:00 CEST