Job step edit error

Question

Job step edit error

Viewing 5 posts - 16 through 19 (of 19 total)

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

peymaster-660178 SSC Veteran Points: 204 More actions · Answer 1

Yeah, I had the same problem with SQL Server 2008 R2 as I wasn't able to add or edit an existing job. Well, I guess that's a bug:w00t:

Here is the fix for it from Microsoft:

http://support.microsoft.com/kb/2315727

Cheers

jfogel SSCarpal Tunnel Points: 4155 More actions · Answer 2

I ended up having to unregister and reregister all DLL files in that directory.

Cheers

SQlLogic SSCrazy Eights Points: 9686 More actions · Answer 3

@jfogel

can you explain in detail how you unregister and reregister the dll files.. and which dll files did u register?

jfogel-1131029 SSC Veteran Points: 235 More actions · Answer 4

See post 4 in this thread and change Program Files\Microsoft SQL Server\90\DTS\binn 90 to 80 if this is SQL2K. I have a tool that lets me unregister and reregister one or more files at a time instead of using regsvr32 for each individual file. You could create a batch file using something like dir *.dll /b > c:\tmp\list.bat. That will create a file with a bare list of dll files so just place regsvr32 -u in front of each file name. Run that to unregister then use the replace function to get rid if the -u and rerun the file to register. My issue was not solved by reregistering a single dll. I did the whole directory.

John Esraelo-498130 SSCertifiable Points: 5914 More actions · Answer 5

I had the same issue and restarting MSSMS fixed it..

Cheers,
John Esraelo