• Grey Twitter Icon
  • Grey Facebook Icon
  • Grey LinkedIn Icon
  • Grey Google+ Icon

© 2016 - 2019 All rights reserved. PigeonSQL.com | Filip Holub

How to Get Owner of Job in SQL Server?

February 19, 2017

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!

 

 

 

Please reload

RECENT POST
Please reload

  • Facebook Social Icon
  • Google+ Social Icon
  • LinkedIn Social Icon
  • Twitter Social Icon