2

In SQL Server 2008, if one would want multiple email addresses to be notified when a Job Succeeds or Fails, he would have to Assign Email notification to an Operator in Job Properties -> Notifications.

In my case, due to email domain length, I can only enter 3 email address in Operator's "Email Name" Field.

Is there any way out so that i can allow notification to 3+ email addresses?

Note : An option to assign multiple operator to a Job notification also would do.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Abdul K
  • 73
  • 1
  • 7

2 Answers2

2

Only up to 128 characters. This is the max length of the sysname datatype

See:

SQL Server: Maximum character length of object names

Community
  • 1
  • 1
divan
  • 29
  • 2
0

The Email Name length in SQL Server 2008 R2 is 100 characters. The problem is that if you type a longer value it will cut it.

Frank Goortani
  • 1,407
  • 17
  • 26