Unable to open Alerts in SQL Server Agent / Cannot view properties

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Unable to open Alerts in SQL Server Agent /...

Unable to open Alerts in SQL Server Agent / Cannot view properties

Rate Topic

Display Mode

Topic Options

Author

Message

Musab-946967

Posted Friday, November 16, 2012 1:53 AM

Valued Member

Group: General Forum Members
Last Login: 2 days ago @ 10:32 AM
Points: 63, Visits: 445

I am unable to open Alerts in SQL Server Agent and Cannot view the properties using GUI.
Although I am able to create and modify alerts via Script
It gives me this exception.
Anybody has any idea ?

===================================

Cannot show requested dialog.

===================================

Cannot show requested dialog. (SqlMgmt)

------------------------------
Program Location:

at Microsoft.SqlServer.Management.SqlMgmt.DefaultLaunchFormHostedControlAllocator.AllocateDialog(XmlDocument initializationXml, IServiceProvider dialogServiceProvider, CDataContainer dc)
at Microsoft.SqlServer.Management.SqlMgmt.DefaultLaunchFormHostedControlAllocator.Microsoft.SqlServer.Management.SqlMgmt.ILaunchFormHostedControlAllocator.CreateDialog(XmlDocument initializationXml, IServiceProvider dialogServiceProvider)
at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm.InitializeForm(XmlDocument doc, IServiceProvider provider, ISqlControlCollection control)
at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm..ctor(XmlDocument doc, IServiceProvider provider)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ToolMenuItemHelper.OnCreateAndShowForm(IServiceProvider sp, XmlDocument doc)
at Microsoft.SqlServer.Management.SqlMgmt.RunningFormsTable.RunningFormsTableImpl.ThreadStarter.StartThread()

===================================

Failed to create/initialize Agent Alert dialog. (SqlManagerUI)

------------------------------
Program Location:

at Microsoft.SqlServer.Management.SqlManagerUI.AgentAlert..ctor(CDataContainer dataContainer)

===================================

Cannot create/initialize Response page. (SqlManagerUI)

------------------------------
Program Location:

at Microsoft.SqlServer.Management.SqlManagerUI.AgentAlert.AddResponsePage()
at Microsoft.SqlServer.Management.SqlManagerUI.AgentAlert..ctor(CDataContainer dataContainer)

===================================

Object reference not set to an instance of an object. (SqlManagerUI)

------------------------------
Program Location:

at Microsoft.SqlServer.Management.SqlManagerUI.AgentAlertResponse.RefreshJobComboBoxAndSelectJob(Job currentJob)
at Microsoft.SqlServer.Management.SqlManagerUI.AgentAlertResponse.RefreshJobComboBox()
at Microsoft.SqlServer.Management.SqlManagerUI.AgentAlertResponse..ctor(CDataContainer dataContainer, String agentAlertName)
at Microsoft.SqlServer.Management.SqlManagerUI.AgentAlert.AddResponsePage()

Musab
http://www.sqlhelpline.com

Post #1385540

Kevin Roberts

Posted Tuesday, January 29, 2013 11:21 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, May 13, 2013 10:23 AM
Points: 1, Visits: 117

I had the same problem and found the page below. I had two SSRS Jobs show up with the same name.

select name from msdb.dbo.sysjobs group by name having count(*) >1

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=172364

Post #1413208

« Prev Topic | Next Topic »

Permissions