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' )
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.
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 ;-))
Click Here to Expand Forum to Full Width