Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Sending SMS alerts in case of sql job failure

Author  Topic 

tanveerahmed
Starting Member

6 Posts

Posted - 2008-12-01 : 02:11:38
HI,

We have some important sql jobs running on a server. We want a notification if any of these jobs fails through SMS on mobile.

Is it possible ? Please assist us how to configure the same ?

Thanks

shaunc
Starting Member

28 Posts

Posted - 2008-12-02 : 16:46:20
This depends on your cell provider. Most of them have email-to-sms gateways where yourphonenumber@example.com will send a text message to your phone. If your telco supports this, set the Pager Email associated with your Operator account on the server. Then, set the job to notify your pager when it fails.
Go to Top of Page

hjh321
Starting Member

3 Posts

Posted - 2010-09-20 : 10:19:29
spam removed
Go to Top of Page
   

- Advertisement -