SQL Server job property throwing errors

Question

SQL Server job property throwing errors

M&M

SSC-Insane

Points: 21700
More actions
October 7, 2010 at 11:54 pm

#224828

This is a SQL Server 2005 instance. When I try to view job property on SQL Server Agent, I get below error message.
TITLE: Microsoft SQL Server Management Studio
------------------------------
Cannot show requested dialog.
------------------------------
ADDITIONAL INFORMATION:
Cannot show requested dialog. (SqlMgmt)
------------------------------
Enumerate target servers failed for Job 'ALL_SYSDB_FULL.Subplan_1'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Enumerate+target+servers+Job&LinkId=20476
------------------------------
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
String or binary data would be truncated. (Microsoft SQL Server, Error: 8152)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.4053&EvtSrc=MSSQLServer&EvtID=8152&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
SP3 is installed on this server. Also, the peculiar thing is, facing issues for all database jobs. All of them are maintenance plans only.
Kindly provide your suggestions for resolution
M&M

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Adiga One Orange Chip Points: 27284 More actions · Answer 1

ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTempl

From the error message it is clear SSMS is still running on SQL Server 2005 SP2. Please upgrade the client components to SP3

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

M&M SSC-Insane Points: 21700 More actions · Answer 2

You are absolutely right. I tried this from another client and I was able to view the job properties etc.

My question is, on a client machine how do I check the SP version. Please suggest.

M&M

Adiga One Orange Chip Points: 27284 More actions · Answer 3

Click on SSMS --> Help --> About. The first row in the screen mentions about the SSMS version.

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga