Pager notification doesn't work 1

[andreis]

Hi, our SQL Server 2005 e-mail notification (Database Mail) works fine, but pager doesn't. The pager works, I sent messages to it from regular email. All settings on Alert System property of SQl Agent seem fine. Do we need a third-party soft on mail server for pager to work? How can we get paging from SQL Server to life? Thanks.

 

[mrdenny]

The SQL Server can use an email address of the pager only. You can't just put in the pager's phone number.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog

 

[andreis]

Denny, thanks, I beleive we enter email address of the pager, like 1234@567.com. SQL Server attempts to send out the message, but it doesn't arrive. Andrei.

 

[mrdenny]

Check your SMTP server to make sure that the email is getting there. If there are no errors in the SMTP server logs then it is being blocked somewhere else.

You can also check the Database Mail logs.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog