SQLServerCentral / SQL Server 2008 / SQL Server Newbies / Need to find user accounts that are running jobs / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 04:42:58 GMT20RE: Need to find user accounts that are running jobshttp://www.sqlservercentral.com/Forums/Topic1369561-1292-1.aspxThanks Perry!Sun, 07 Oct 2012 20:41:02 GMTjdbrown239RE: Need to find user accounts that are running jobshttp://www.sqlservercentral.com/Forums/Topic1369561-1292-1.aspxThe following should help[code="SQL"]SELECT jobs.name, jobs.enabled, SUSER_SNAME(jobs.owner_sid) as OwnerFROM msdb.dbo.sysjobs as jobs[/code]Sun, 07 Oct 2012 16:23:46 GMTPerry WhittleNeed to find user accounts that are running jobshttp://www.sqlservercentral.com/Forums/Topic1369561-1292-1.aspxI 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?Sun, 07 Oct 2012 12:42:04 GMTjdbrown239