sys.sp_manage_jobs_by_login
general #stored-procedure
Description
Deletes or reassigns jobs that belong to the specified login. The action to take for the specified login. The login name of the current job owner. The login name of the new job owner.
Syntax
sp_manage_jobs_by_login