Advanced Search

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