Renamed Server, Now thinks it has Remote Job

• kknudson

  SSCarpal Tunnel

  Points: 4986

  More actions

  July 7, 2004 at 8:21 am

  #85844

  I renamed my dev server, now one of the maintenance plans thinks it was created under remote admin.

  I can't change it or delete it.

  Short of going into the syatem tables any way to get rid of it ??

  
  KlK

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736479

  More actions

  July 7, 2004 at 8:34 am

  #513664

  http://www.sqlservercentral.com/columnists/sjones/killthattarget.asp

• neder

  SSC Eights!

  Points: 888

  More actions

  July 7, 2004 at 2:11 pm

  #513730

  check the originating_server column in msdb..sysjobs table.  verify as well the server name (select @@servername) if this match the new name. 

• kknudson

  SSCarpal Tunnel

  Points: 4986

  More actions

  July 7, 2004 at 2:17 pm

  #513736

  Thanks Steve, that article hit it right.

  
  KlK