Tuesday, July 8, 2014

Error while trying to open ALERTS in SQL Server

Here below is the error i got while trying to open ALERTS from sql server. The version i had here is SQL 2012.

TITLE: Microsoft SQL Server Management Studio
------------------------------
Cannot show requested dialog.
------------------------------
ADDITIONAL INFORMATION:
Cannot show requested dialog. (SqlMgmt)
------------------------------
Failed to create/initialize Agent Alert dialog. (SqlManagerUI)
------------------------------
Cannot create/initialize Response page. (SqlManagerUI)
------------------------------
An item with the same key has already been added. (mscorlib)
------------------------------
BUTTONS:
OK
------------------------------


ISSUE
Issue here is that we have Agent Jobs set up with the same name.
From the error message, we see this: An item with the same key has already been added. (mscorlib)
It means there are two jobs with the same name. In this situation, SQL Server will prevent all operations on alert. 

RESOLUTION
We need to find the duplicate jobs and either rename them or delete them if not required. This should fix the issue.

MvM

No comments:

Post a Comment