MSDB

• tosscrosby

  Hall of Fame

  Points: 3140

  More actions

  October 28, 2003 at 2:39 pm

  #64747

  I inherited a machine with SQL 2000 sp3 with a name change to the server and the SQL instance. When I try to change a job scheduled in the SQL Agent I get a message stating "Cannot add, update or delete a job that originated from an MSX server. job not changed". Microsoft says to rename the server to it's original name, script the jobs, delete them, rename the server to it's new name and recreate the jobs. I'm wondering, can I just update the originating_server column on msdb.sysjobs with the new server name??

  Terry

  
  Terry

• philcart

  SSC-Forever

  Points: 47797

  More actions

  October 28, 2003 at 3:21 pm

  #479988

  I've successfully done just that on a couple of occasions, haven't had any problems.

  I suppose MS is just protecting themselves by not advsing users to directly update system tables.

  Hope this helps

  Phill Carter

  --------------------

  Colt 45 - the original point and click interface

  --------------------
  Colt 45 - the original point and click interface

• billyburns

  Ten Centuries

  Points: 1108

  More actions

  October 29, 2003 at 6:19 am

  #480077

  I had to do the same thing....no problems yet....

  UPDATE sysjobs

  SET originating_server = convert(nvarchar(30), serverproperty(N'servername'))

  WHERE originating_server != convert(nvarchar(30), serverproperty(N'servername'))

  bb