Re: SQLServerAgent Error on operator

Re: SQLServerAgent Error on operator

 

  


Would more sensible to create then one mailing address.


At 11:27 AM 8/20/2003 -0400, sang.[Email Address Removed] wrote:
>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
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page