SQL Server Agent - Operators

_{Monday, August 25, 2014 7:09 AM}

Hi,

When I tried to configure an operator in SQL server job agent then i can't add more than 100 characters in "email name" field.

Any thoughts??

_{Tuesday, August 26, 2014 7:43 AM ✅Answered | 1 vote}

No. I want to add multiple email addresses. but issue is when total length of characters of all email addresses reaches to 100, it cut down additional characters.

Example: abc@example.com;xyz@example.com;........; example@example.com

now assume we have total 102 characters, SQL will cut down down the last two characters and will make my last email address as "example@example.c"

Hi Muhammad,

SQL  Server operator email addresses are limited to 100 characters. The behavior is by design.

To work around this issue, you can create a group email in Exchange server, add all the emails you want into the group, then use the group email address when configuring the operator.

For more information, please review the following link:
sp_add_operator (Transact-SQL): http://technet.microsoft.com/en-us/library/ms186747.aspx

Regards,
Lydia Zhang

_{Tuesday, August 26, 2014 10:24 AM ✅Answered}

Hi Muhammad,

To add to what lydia suggested, another workaround could be to add multiple operators for the same alert. This way you will not depend on a DL from Exchange server or other mail servers.

HTH

_{Tuesday, August 26, 2014 10:55 AM ✅Answered}

you can check lenght in msdb dB

select * from dbo.sysoperators 

_{Monday, August 25, 2014 7:21 AM}

Do you have email whose address length is greater than 100 characters ?

Regards, RSingh

_{Monday, August 25, 2014 7:32 AM}

No. I want to add multiple email addresses. but issue is when total length of characters of all email addresses reaches to 100, it cut down additional characters.

Example: abc@example.com;xyz@example.com;........; example@example.com

now assume we have total 102 characters, SQL will cut down down the last two characters and will make my last email address as "example@example.c"

_{Tuesday, August 26, 2014 12:41 PM}

Thanks All

I want to let Microsoft know about this so that they can consider it in next release. What is the way for that?

_{Wednesday, August 27, 2014 12:32 AM}

Thanks All

I want to let Microsoft know about this so that they can consider it in next release. What is the way for that?

Hi Muhammad,

Personally, I recommend you that submit the requirement at https://connect.microsoft.com/SQLServer/ .  If the requirement mentioned by customers for many times, the product team may consider to add this feature in the next SQL Server version. Your feedback is valuable for us to improve our products and increase the level of service provided.

Thanks,
Lydia Zhang

_{Saturday, June 2, 2018 12:42 PM}

Please execute below script, it will allow character as required.

USE mdsdb
GO
ALTER TABLE sysoperators
ALTER column email_address NVARCHAR(2000);