Posted By

pollusb on 03/20/09


Tagged

migration admin


Versions (?)

Unable to delete or disable SQL Server job due to error regarding MSX server


 / Published in: SQL
 

URL: http://blogs.msdn.com/mab/archive/2008/01/26/unable-to-delete-sql-server-job-due-to-error-regarding-msx-server.aspx

This is a simplified version to resolve the error "Unable to delete or disable SQL Server job due to error regarding MSX server" when migrating a server

  1. SELECT originating_server FROM msdb..sysjobs
  2.  
  3. UPDATE msdb..sysjobs
  4. SET originating_server = CAST(SERVERPROPERTY('ServerName') AS sysname)
  5.  
  6. SELECT originating_server FROM msdb..sysjobs

Report this snippet  

You need to login to post a comment.