Operator email list

• SkyBVI

  SSCoach

  Points: 15128

  More actions

  September 8, 2010 at 9:56 am

  #148686

  Hi,

  I running a job which sends an email to 7 users if the job fails.

  I went to SSMS-->sql server agent--> operators....made a new operator and included all emails of those 7 users.

  Then included that operator in the notification option in the job.

  All was set.

  BUT when I again went to the operator and checked the emails, it automatically truncated the last 2( that means it can take only a specified number of alphabets). I again tried to add last 2, but in vain...

  So, that means it can't take more than speciifed emails(or alphabets) or it just shows that?? but will send emails to all of them.

  If it wont send emails to all of them, then how can i send emails to all of them

  Thanks,

  Regards,

  Sushant

  Regards
  Sushant Kumar
  MCTS,MCP

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  September 8, 2010 at 11:12 am

  #1218116

  Looks like the GUI has a restriction of 256 characters for the email field. However you can also add the operator using T-SQL and it works.

  USE [msdb]

  GO

  EXEC msdb.dbo.sp_add_operator @name=N'OperatorName',

  @enabled=1,

  @pager_days=0,

  @email_address=N'email addresses here'

  GO

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga

• SkyBVI

  SSCoach

  Points: 15128

  More actions

  September 8, 2010 at 12:18 pm

  #1218157

  @ pradeep

  Thxs a lot !!

  Regards,

  Sushant

  Regards
  Sushant Kumar
  MCTS,MCP