Info for master.dbmail.SendPage

Question

Post reply

Info for master.dbmail.SendPage

parth83.rawal

SSCommitted

Points: 1858
More actions
April 30, 2009 at 1:00 am

#384472

Hi the other day i was reading a Doc for sending SMS using SQL Server 2005 in which they simply said that following Proc will send the sms, but i couldn't fine the details for it, Please some body can give me details for it..
The following examples demonstrate how to send pager massages using DB Mail functions.
Example 1, single message
The following EXECUTE statement will send message massages to (111) 222-3344 pager number.
EXEC master.DBMail.SendPage '1112223344',
'Free space in the database is critically low. Your immediate
attention is required'
Thanks
Parth

Viewing 15 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic. Login to reply

parth83.rawal SSCommitted Points: 1858 More actions · Answer 1

parth83.rawal

SSCommitted

Points: 1858

April 30, 2009 at 7:03 am

#986621

Please any body help me out with this.!!!

Adam Bean One Orange Chip Points: 26631 More actions · Answer 2

Can't say I've ever heard of "SendPage" ... you could use database mail (sp_send_dbmail). If you're on SQL2000, you'll need to use SQL Mail and/or a custom extended stored procedure (ie. cdosysmail, xp_smtp_sendmail).

http://msdn.microsoft.com/en-us/library/ms190307.aspx

Example:

EXEC [msdb].[dbo].[sp_send_dbmail]

@recipients='1112223344@carrier.com'

,@subject = 'Low disk space notification'

,@body = 'Free space in the database is critically low. Your immediate attention is required'

parth83.rawal SSCommitted Points: 1858 More actions · Answer 3

Will this be able to send SMSs?????

Let me rephrase my question that will it be possible to send SMS using SQL Server 2005?????

Please Help me out with this.

Thanks in advance.

Parth

parth83.rawal SSCommitted Points: 1858 More actions · Answer 4

How to send SMSs with SQL server 2005,

Please some one give some info.

Thanks

Parth

Adam Durr SSCommitted Points: 1755 More actions · Answer 5

You can use this system sproc to find the details of a stored procedure

use msdb

sp_helptext 'sp_send_DBMail'

You cannot write a stored procedure with a period in it like that. A period is used to separate the server, database, schema, and object names.

I agree with what Adam Bean wrote. You can send a page by supplying the e-mail address of your pager. Its usually your phonenumber@carrier.com

Adam Durr
Remote DBA support
www.bluegecko.net

parth83.rawal SSCommitted Points: 1858 More actions · Answer 6

Hi,

I am agree what you are trying to say, i am trying to send SMSs using database,

basically i am able to send the data using an SMS Gateway, but i want to send it using database,

is it possible ?? if yes then give me some psuedo code.

Thanks

Parth

Adam Bean One Orange Chip Points: 26631 More actions · Answer 7

parth83.rawal (5/4/2009)
Hi,
I am agree what you are trying to say, i am trying to send SMSs using database,
basically i am able to send the data using an SMS Gateway, but i want to send it using database,
is it possible ?? if yes then give me some psuedo code.
Thanks
Parth

Again, you can send email to a text address as such:

EXEC [msdb].[dbo].[sp_send_dbmail]

@recipients='1112223344@carrier.com'

,@subject = 'Low disk space notification'

,@body = 'Free space in the database is critically low. Your immediate attention is required'

Have you tried it yet?

parth83.rawal SSCommitted Points: 1858 More actions · Answer 8

[@recipients='1112223344@carrier.com'

what does this mean sir,

what is this carrier name ???????

Adam Bean One Orange Chip Points: 26631 More actions · Answer 9

parth83.rawal (5/4/2009)
[@recipients='1112223344@carrier.com'
what does this mean sir,
what is this carrier name ???????

The cell phone provider ... ie Verizon = @vtext.com

manolomalaga SSCommitted Points: 1697 More actions · Answer 10

Here is a very clear sample code

http://www.siccolo.com/Articles/SQLScripts/how-to-create-trigger-to-sms-email.html

parth83.rawal SSCommitted Points: 1858 More actions · Answer 11

Thanks for the Reply,

here in receipant what should i write: 99999999@airtel.com??

what puzzeled me most is who is gonna pay for my SMSs and what kind of profile i have to create in order to sent SMSs ???

can you please provide the details for it???

Thanks

Parth

atoth SSC-Addicted Points: 462 More actions · Answer 12

Re: Sending SMS from SQL Server

I have use a couple of approaches successfully:

1. Use SMS provider who can give you an SMTP Gateway (nearly all if them do!)

2. I have used a SMS supplier who provided com objects which I used from the Server directly (I don't like using com from SQL Server but it works)

Adam

parth83.rawal SSCommitted Points: 1858 More actions · Answer 13

Thanks for all your Replies but i have manage to work it....!!!

but still i have a confusion who is gonna pay for it???

what i have done is? i have used a phonenumber@airtelkk.com , and send mail and it reached as SMS to the user.

but when i asked to the cutomer care about it, they even dont know about this domail name....!!

but it is working now.......till the time we are not in any trouble.....heeheh

Thanks

Parth

Adam Durr SSCommitted Points: 1755 More actions · Answer 14

Straight answer: whoever is paying your sms bill.

Adam Durr
Remote DBA support
www.bluegecko.net