Advanced Search

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

/ Published in: SQL
Save to your folder(s)
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

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  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

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

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.