current community

your communities

more stack exchange communities

Stack Exchange
tour help
Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

In SSMS on a Windows 7 machine, while connecting to a server running SQL Server 2000, I am no longer able to click on the Jobs to see the Object Explorer Details. Previously, this was not an issue, but it appears to have begun not long after a re-start of the SQL Server Agent.

Failed to retrieve data for this request. ...

Severity: 11
Error Number: 0
State: 0

In SQL Server Enterprise Manager on my XP machine, I am able to view the Job details, but it takes a long time; trying to view the properties of an individual Job also takes an inordinate amount of time.

In SSMS, I am not having any trouble opening tables and running queries or opening procs and running them.

Any insight into causes and/or fixes?

share|improve this question
    
When was the last time you cleared out the agent history? What is the connectivity between the Windows 7 machine and the 2000 server? What happens if you RDP to the 2000 server and load SQL Server Agent locally in the RDP session? –  Aaron Bertrand♦ Apr 15 '14 at 12:29
    
@AaronBertrand - Connectivity is good. msdb.sysjobhistory shows about 6500 records, with 90% of the records having been created in 2014. –  mg1075 Apr 15 '14 at 12:41
    
@AaronBertrand - RDP into the 2000 box indicates the same slowness for SQL SErver Agent jobs display. –  mg1075 Apr 15 '14 at 12:47
    
This seems like a timeout issue, so I'm not quite convinced of your assessment that "connectivity is good." How have you come to that conclusion? –  Aaron Bertrand♦ Apr 15 '14 at 12:48
    
@AaronBertrand - When I connect to the server, I do not experience lag time; when I open a table or open a proc, I do not experience lag time; when I run a basic query, I do not experience lag time; yet whenever I attempt to view the Job Details under SQL Server Agent, the lag time is significant. –  mg1075 Apr 15 '14 at 12:52

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.