Show pageOld revisionsBacklinksExport to PDFBack to top This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong. ====== MSSQL - Query Jobs with Owners ====== <code sql List jobs> SELECT s.name AS JobName, l.name AS JobOwner FROM msdb..sysjobs s LEFT JOIN master.sys.syslogins l ON s.owner_sid = l.sid WHERE l.name IS NOT NULL ORDER by l.name </code> <code sql Reassign jobs> USE msdb ; GO EXEC dbo.sp_manage_jobs_by_login @action = N'REASSIGN', @current_owner_login_name = N'sa' @new_owner_login_name = N'QUICK\Pinal', ; GO </code> database/mssql/list_jobs.txt Last modified: 2020/12/02 14:35by 127.0.0.1