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?

RECENT POST
bottom of page