Hi,

I used the following script to generated 'sysdba1' operator:

EXECUTE msdb.dbo.sp_add_operator @name = N'sysdba1', @enabled = 1,
@email_address = N'Nahm, Sang Y;Nardo, Henry;Burton, Jeffery B;Oechsler,
Mary;Evans, Pamela',
@netsend_address = N'ris496', @category_name = N'[Uncategorized]',
@weekday_pager_start_time = 80000, @weekday_pager_end_time = 180000,
@saturday_pager_start_time = 80000, @saturday_pager_end_time = 180000,
@sunday_pager_start_time = 80000, @sunday_pager_end_time = 180000,
@pager_days = 62

But when I test it in its properties window, I get the following Error:

Error 22022: SQLServerAgent Error. Unable to resolve email recipients name
'Oechsler, Maryy B' (Reason: One or more of the recipients was not found in
the address book).

It seems as though sysdba1 is defined with compressed recipient list.

Thank you,

Sang
x6746

MS Sql Server LazyDBA home page