how to use pager notification when job is done

[stanja]

Hello ,

I want to use the pager notification when a job is done.
How can i do this , i want to send an sms to my mobile.
Must the server be connected to a phone line or is internet access enough and how then to sent it ?
Any help would be grate

grtz
Stanja

 

[onpnt]

Mobile companies provide you with a way to email phones just as a regular email to a pop server. So you can simply send a email to the phone for a page. This is how I've done it and it works well.

You can find you correct email format out of this list of providers

http://www.livejournal.com/tools/textmessage.bml?mode=details

[sub]____________ signature below ______________
The worst mistake you'll ever make is to do something simply the way you know how while ignoring the way it should be done[/sub]

 

[mrdenny]

SQL can't send SMS directly. As onpnt said, get the actual email address for your phone, and have the SQL Server send an email to that email address.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com