Job step edit error

• peymaster-660178

  SSC Veteran

  Points: 204

  More actions

  April 3, 2011 at 10:47 pm

  #1306850

  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

  May 16, 2011 at 7:48 am

  #1325051

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

  Cheers

• SQlLogic

  SSCrazy Eights

  Points: 9686

  More actions

  March 7, 2012 at 2:36 pm

  #1456261

  @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

  March 7, 2012 at 3:45 pm

  #1456308

  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: 5916

  More actions

  June 12, 2012 at 12:08 pm

  #1499964

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

  Cheers,
  John Esraelo