top of page

How to Get Owner of Job in SQL Server?

There are two ways how to find out owner of job. First way is open every job and look at owner, if you have 250 jobs it may take a long time. Second way is much better, at least for me. You can use two system tables SYSJOBS in MSDB datbase and SYSLOGINS in Master database.

Bye!

How to Get Owner of Job in SQL Server?

Comments


RECENT POST
  • Grey Twitter Icon
  • Grey Facebook Icon
  • Grey LinkedIn Icon

© 2020 All rights reserved. PigeonSQL.com | Filip Holub

bottom of page