I have a sql login for windows group.
One of the members of ths group was also added as a sql login. This user has 1 job in which he is registered as the owner.
I want to remove this user login because he is already part of group membership.
If I try to delete the user (assuming he will retain all his permissions via the group membership), then it gives an error that there is 1 job owned by this user.
How to remove this login, and keep the jobs, and also ensure that the user retains permission that it has inherited via the group membership?