Alert message to mobile

[jonnyk]

Is it possible to set up an alert to contact a mobile phone using a text message

 

[NathanGriffiths]

I don't think you can do this from SQL Server.

However, you might be able to use something like Outlook Mobile Information server to forward e-mail alerts to a mobile device.

http://www.microsoft.com/miserver/evaluation/features/default.asp

 

[SQLSister]

YOu can't even send a phone number page without third party software, so I presume you would need to search the net for some third Party software to do this.

 

[cheyney]

aren't text messages just sent via email?

if I send an email to [myphonenumber]@msg.telus.net, i get it as a text message on my phone.

maybe this is just a service provided by my cell phone company (?)

I've set up an asp page that I can enter in a date,time,and message, it creates a sql scheduled task that emails my phone at that time with my message...kind of a reminder/wakeup service...so its do-able with my setup

cheyney

 

[bytehd]

Yep, i do it with SPRINT PCS all the time.
SMS messages are sent to the users phone number in the body of the message.

check this out:

Function Main()
Dim objFSO, strFullName, x, txtSHOP
Set objFSO = CreateObject("Scripting.FileSystemObject&quot


For x = 1 To 16
if x<>4 then

IF x<10 then
txtSHOP=&quot;00&quot;+cstr(x)
else
txtSHOP=&quot;0&quot;+cstr(x)
end if

If objFSO.FileExists(&quot;D:\SQLTXT\SHOP&quot;+txtSHOP+&quot;\revwk.txt&quot Then
else
Set objSendMail = CreateObject(&quot;CDONTS.Newmail&quot
with objSendMail
.From = &quot;SQL2000@company.com&quot;
.To = &quot;user@sms_provider.com&quot;
.Subject = &quot;No Text for shop &quot;+ txtSHOP
.Body = &quot;No Text Files for Shop &quot; + txtSHOP
.Send
end with
set objSendMail = Nothing
end if
end if
next
Main = DTSTaskExecResult_Success

End Function

cool?

 

[bytehd]

P.S.
I use CDONTS exclusively after reloading SQL mail, outlook, Windows and SQL too many times to care about that piece of $%#@$% anymore.

 

[tlbroadbent]

We use SQLMail exclusively and have experienced only minor inconveniences. If you want to get the best answer for your question read faq183-874 and thread183-468158.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm