Info for master.dbmail.SendPage

  • 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

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

  • 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'

  • 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

  • How to send SMSs with SQL server 2005,

    Please some one give some info.

    Thanks

    Parth

  • 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

  • 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

  • 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?

  • [@recipients='1112223344@carrier.com'

    what does this mean sir,

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

  • 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

  • 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

  • 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

  • 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

  • Straight answer: whoever is paying your sms bill.

    Adam Durr
    Remote DBA support
    www.bluegecko.net

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

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