Simon:
There are lots of ways to handle this task.
Here's what I do. I have a server (machine and
database)
that is on my main network. In the database on that
server
is a special table. If I want to send an e-mail from
within
Oracle, I simple insert a row into this table and commit
it.
If I want to send an e-mail from UNIX, I formulate the
message and insert the row from a ksh script.
The Before-Insert trigger on this table fires and calls
a
stored procedure that formats a message and uses the
UTL_SMTP stored procedure to send an e-mail. A
side-effect
of this method is a table of sent messages and their
times.
I have a stored table of user and administrator data,
so
if the insert command says to send a page, the e-mail
goes
to the stored pager address and number. If I just want
to
send an email, the messages goes to their standard
e-mail
address. I can send to both, too, and I can also send
to
a personal pager.
Yes, this depends on the machine being on the network,
and
being connected to the internet. However, you could
have
a process set up to dial a modem and send the message,
too.
Good Luck!
Cheers,
Mike
-----Original Message-----
From: FOX, Simon [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 13, 2002 6:03 AM
To: Multiple recipients of list ORACLE-L
Subject: Telephone AlertsWe have some UNIX batch processes that send us e-mails when they have finished.Does anyone have any experience of sending a SMS message to a mobile phone?
Simon Fox
