Search
  • Filip Holub

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!


123 views
  • Grey Twitter Icon
  • Grey Facebook Icon
  • Grey LinkedIn Icon

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

  • Twitter Social Icon
  • Facebook Social Icon
  • LinkedIn Social Icon