SQL SERVER – FIX: Msg 15170, Level 16, This login is the Owner of 1 Job(s). You Must Delete or Reassign these Jobs Before the Login can be Dropped
How to fix #SQL #SERVER error #15170 ?
As mentioned in the error message, this is due to dependency of job on the account which we are trying to delete. We need to find out such jobs so that suggested action can be taken.
SELECT name,*
FROM msdb..sysjobs
WHERE owner_sid = SUSER_SID('foo')
You need to replace “foo” which the user name which you are trying to delete. The output of the query would show the jobs which are owned by this login.
More Info >>
https://ibmimedia.com/blog/95/solve-sql-server-error-15170
