Return to Snippet

Revision: 12609
at March 20, 2009 18:09 by pollusb


Initial Code
SELECT originating_server FROM  msdb..sysjobs 

UPDATE msdb..sysjobs 
SET originating_server = CAST(SERVERPROPERTY('ServerName') AS sysname)

SELECT originating_server FROM  msdb..sysjobs

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

Initial Description
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

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

Initial Tags


Initial Language
SQL