Cacher is the code snippet organizer for pro developers

USE [msdb];
 
SET NOCOUNT ON;
 
DECLARE @NewOwnerLoginName [sysname] = N'sa' --// <-- Specify user to own all SQL Server Agent jobs
 
----------------------------------------------------------------------------------------------------
--// Internal script local variables                                                           //--
----------------------------------------------------------------------------------------------------
DECLARE @SQLStatementID01   [int] ,
        @CurrentCommand01   [nvarchar](MAX) ,
        @ErrorMessage       [varchar](MAX) 
 
IF OBJECT_ID(N'TempDb.dbo.#Work_To_Do') IS NOT NULL
    DROP TABLE #Work_To_Do 
CREATE TABLE #Work_To_Do
    (
      [SQLID] [int] IDENTITY(1, 1)
                    PRIMARY KEY ,
      [JobName] [sysname] ,
      [TSQL_Text] [varchar](1024) ,
      [Completed] [bit]
    )
 
INSERT  INTO #Work_To_Do
        ( [JobName] ,
          [TSQL_Text] ,
          [Completed]
        )
        SELECT  [name] ,
                'EXEC [msdb]..[sp_update_job] @job_name = N''' + [name]
                + N''', @owner_login_name = N''' + @NewOwnerLoginName + N''';' ,
                0
        FROM    [msdb].[dbo].[sysjobs]
 where suser_sname(owner_sid) like 'aesua%'

SELECT  @SQLStatementID01 = MIN([SQLID])
FROM    #Work_To_Do
WHERE   [Completed] = 0
 
WHILE @SQLStatementID01 IS NOT NULL
    BEGIN
 
        SELECT  @CurrentCommand01 = [TSQL_TEXT]
        FROM    #Work_To_Do
        WHERE   [SQLID] = @SQLStatementID01
 
        BEGIN TRY
            select @CurrentCommand01
			EXEC [sys].[sp_executesql] @CurrentCommand01
        END TRY
        BEGIN CATCH
 
            SET @ErrorMessage = N'"Oops, an error occurred that could not be resolved. For more information, see below:'
                + CHAR(13) + ERROR_MESSAGE() 
 
            RAISERROR(@ErrorMessage,16,1) WITH NOWAIT
 
            GOTO ChooseNextCommand
        END CATCH
 
        ChooseNextCommand:
 
        UPDATE  #Work_To_Do
        SET     [Completed] = 1
        WHERE   [SQLID] = @SQLStatementID01
 
        SELECT  @SQLStatementID01 = MIN([SQLID])
        FROM    #Work_To_Do
        WHERE   [Completed] = 0
    END
 
SET NOCOUNT OFF;