Post reply

Need to find user accounts that are running jobs

  • October 7, 2012 at 12:42 pm

    #263650

    I keep running in to jobs that are running under the account of the previous DBA that held my new position. Is there an easy way to query for what accounts jobs are running under?

  • October 7, 2012 at 4:23 pm

    #1546529

    The following should help

    SELECT jobs.name,

    jobs.enabled,

    SUSER_SNAME(jobs.owner_sid) as Owner

    FROM msdb.dbo.sysjobs as jobs

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • October 7, 2012 at 8:41 pm

    #1546546

    Thanks Perry!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply