How To Change Job Owner for all JOBS In MS SQL SERVER

preview_player
Показать описание
QUERY:
SELECT NAME,SUSER_SNAME(OWNER_SID) AS JOB_OWNER FROM MSDB.DBO.SYSJOBS

SELECT 'EXEC MSDB.DBO.SP_UPDATE_JOB @JOB_ID=N'''+ CONVERT(VARCHAR(MAX) ,JOB_ID) + CHAR(39)+ ', @OWNER_LOGIN_NAME=N''SA''' FROM MSDB.DBO.SYSJOBS
  1. MS SQL DBA Tech Support
  2. sql server
  3. change job owner SQL server
  4. SQL server agent job owner change
  5. T-SQL change job owner
  6. SQL server agent job ownership
Комментарии
Автор

Very Helpful Sir,
Can't we change through GUI.
Thank You

iKriyaYogi