richbrownesq


Apologies if this is in the wrong forum.

I've set up an email alert to an Operator who can only be alerted via email. When i view the history of this operator, it has a "most recent notification attempt" value against by net send and not against by e-mail. The value is the correct date of the latest email alert, but is just set against the wrong notification type.


Not a major bug for me, but does anyone else have this problem

--------------------------------------------------------------------------

DDL statement for operator.

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

@enabled=1,

@weekday_pager_start_time=90000,

@weekday_pager_end_time=180000,

@saturday_pager_start_time=90000,

@saturday_pager_end_time=180000,

@sunday_pager_start_time=90000,

@sunday_pager_end_time=180000,

@pager_days=0,

@email_address=N'rich@rich.net,

@category_name=N'[Uncategorized]'





Re: Incorrect Information in SQL Agent\Operator History

Robert Wafle


Yup.

Same problem here.

Rob






Re: Incorrect Information in SQL Agent\Operator History

rottengeek

There is a hotfix for this.

I couldn't find the link, but I've been researching the hotfixes for some of the problems I've been having, and this was definately one of them.







Re: Incorrect Information in SQL Agent\Operator History

richbrownesq

This issue still exists in SQL2005 Standard 9.00.3042.00. Its been raised as a bug (#124871) back in Feb 2006 but is still present.

Does anyone know if\when this is going to be fixed for good I've not seen any hotfix information regarding it.

(Please move to the Tools forum)