July 25, 2006 at 11:35 pm
I am setting up notification via SMS. I have entered the email address for my mobile phone into the pager address of the SQL Agent Operator.
My problem is that if the email (including subject and text) exceeds 160 characters, it will send a two part SMS, charging me for two SMS messages when I only need one.
I was wondering if there was any way to limit the number of characters sent to the pager to 160? Is there a way to truncate it?
July 28, 2006 at 8:00 am
This was removed by the editor as SPAM
July 28, 2006 at 10:05 am
the standard pager goes through an extended proc so I doubt you could do much - I don't know if you could create your own proc to handle the pager alerts, thus limiting the message. Don't know too much about this, sorry.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
July 28, 2006 at 10:15 am
I'm not real familiar with SMB either. But i think you could just truncate your message when you call the transmission procedure.
-- @Message the message you want to send
-- @headerlen the length of the header
-- SendSMB the name of your stored procedure that sends the message
exec SendSMB substring(@Message,1,160-@headerlen)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply