Home All Groups Group Topic Archive Search About

Sql Agent Connection problem

Author
23 Oct 2007 3:06 PM
Greg
Hi,
   I'm running SQL 2005. My maintenance jobs have stopped running. If I open
an existing job I noticed that it can no longer make a connection. When I
click on the new connection , i can find the sql server and enter all the
info. needed, when I click ok the connection field it's still blank. When I
try the drop down it gives me the following error:  unhandled exception has
occured. Object reference not set to an instance of an object. I can create
new jobs but I have the same problem. I cannot delete jobs without problems.
I'm able to run SQL jobs from another server housing sql 2005 to the server
to this server. Any help would be appreciated. Thank You in advance
--
Greg

AddThis Social Bookmark Button