September 14, 2010 at 4:06 am
Hi,
I have a bit of an odd problem with SQL 2000, (apologies if in wrong forum).
The issue I have is that I cannot refresh data in Job activity manager using SSMS. Furthermore when I log onto the server itself and look at enterprise manager, I can see all the jobs are there, but none of them have status of 'running' (no matter how many times I refresh). However I know they are as I can see in their history, and also can see jobs running on sp_who2 active.
The only way I'm able to look at the jobs is to do it via logging onto the server itself. If I looking at job activity monitor I get the following message:
TITLE: Activity Monitor
------------------------------
Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
A severe error occurred on the current command. The results, if any, should be discarded. (Microsoft SQL Server, Error: 0)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.2223&EvtSrc=MSSQLServer&EvtID=0&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
I have tried restarting SQL Agent, and have checked it's login account and I still get the same issue.
Has anyone come across this before? I would rather not resort to restarting the server if possible, as it is only SQLAgent that is the problem.
Cheers,
Sam
September 14, 2010 at 5:53 am
I could not repro the issue on SSMS 9.00.4035. Which version of SSMS are you using?
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
September 14, 2010 at 7:28 am
Hi,
My gut instinct is that this is not a SSMS issue (although could be wrong you never know), i think somthing odd is going on with SQL Agent itself. Reason I say this is because I get the same issue from multiple servers on different versions of SSMS.
The versions I have tried on are:
10.0.2531.0
9.00.4035.00
9.00.4266.00
And still no luck 🙁
September 14, 2010 at 9:14 am
To add to this, running:
msdb.dbo.sp_help_job
Errors out with:
Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
I have done a DBCC checkdb (msdb), and got no errors.
Anyone have any ideas on what is causing this?
Cheers,
Sam
September 14, 2010 at 10:41 am
To add to this, running:
msdb.dbo.sp_help_job
Errors out with:
Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
Does the SQL Server Error Log has any entries when this error is raised?
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
September 15, 2010 at 2:29 am
Hi,
Sorry for late reply, I cannot see anything in the SQL logs either. We have decided to give the server a restart tonight, as we need to apply some window updates aswell. I'm hoping that this will resolve the issue. I will let you know how I get on.
Cheers,
Sam
September 16, 2010 at 8:32 am
Hi,
Just to conclude, restarting the server seemed to fix the issue. Could not find out what the issue was in end which is frustrating!
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply