An employee left and they are the owner of reports.  Now the reports won't run.  Is there anyway to change the report owner?

DECLARE @OldUserID uniqueidentifier
DECLARE @NewUserID uniqueidentifier
SELECT @OldUserID = UserID FROM dbo.Users WHERE UserName = '<NewUser/domain>'
SELECT @NewUserID = UserID FROM dbo.Users WHERE UserName = '<OldUser/domain>'
UPDATE dbo.Subscriptions SET OwnerID = @NewUserID WHERE OwnerID = @OldUserID and laststatus like 'Failure%'