SMS to Mobile from a Oracle and NT
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: SMS to Mobile from a Oracle and NT

  1. #1
    Join Date
    Apr 2001
    Location
    United Kingdom
    Posts
    31

    Cool

    Hi There!

    Can you please tell me the steps involved in sending a SMS message to a mobile from the database.
    1) When Database crashes
    2) When a particular event accours in a database like a value in a column is modified to a particular value.
    ( a flay which reflects status as warning when it is 'Y' )

    Thanks
    Dosth

  2. #2
    Join Date
    Aug 2000
    Location
    Belgium
    Posts
    342
    1.
    I think to send SMS you need a SMS provider.
    I know some who generate SMS messages by sending a mail to an specific e-mail adress.

    What you could try to do is this :

    Setup e-mail notification in OEM.

    Develop a system that looks at the mails OEM generates, and if necessary make an e-mail to your SMS provider to generate an SMS message to your mobile.

    2.
    When you want to be informed about events happening inside the db, you could use triggers and utl_snmp to generate the appropriate e-mail to the SMS provider.

    Hope somebody else has a better idea because mine is a bit complicated ;-))

    Regards
    Gert


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width