Post reply

Should i increase the maximum lentgh limit of email address under operator in SQL 2005 ?

  • August 12, 2009 at 5:18 am

    #209445

    I have to send mail alert to 10 people when job fails.But i cannot put more than five email address in operator.Total length of email addressess are more than the maximum length limit of email address in

    operator. Is there is any way to increase the maximum length limit of email address in operator?

    Please help me.

  • August 12, 2009 at 7:33 am

    #1037975

    I don't think you can.. But why don't you see about a distribution list on your email server. Send to the "list" and IT handles the distribution to the ten individuals..

    CEWII

  • August 12, 2009 at 11:41 am

    #1038173

    Thanks for reply.

    We can do this by making one group email id for all ten peoples but i don't want to use this option.I want to do it from SQL side.

  • August 12, 2009 at 11:59 am

    #1038184

    Making use of a distribution list, as Elliot suggested, really makes this type of thing quite a bit easier. It also makes it much easier to manage down the road when one of these 10 people get promoted, quits etc. All you do is add their replacement to the Distribution list and you're all set. You don't need to worry about modifying every single job you've set this list up on.

    But that's just my $.02

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • August 12, 2009 at 1:22 pm

    #1038241

    hemant789 (8/12/2009)

    Thanks for reply.

    We can do this by making one group email id for all ten peoples but i don't want to use this option.I want to do it from SQL side.

    Short answer, tough, and what happend when one of them leaves the company, you have to hit all the jobs because you *wanted* to do it one way but the easiest way was to do it the right way..

    CEWII

  • August 15, 2009 at 9:35 am

    #1039840

    Thanks for reply.

    I have done it by creating group email id of all ten people.

Viewing 6 posts - 1 through 5 (of 5 total)

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