Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Need to find user accounts that are running jobs Expand / Collapse
Author
Message
Posted Sunday, October 7, 2012 12:42 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, August 8, 2014 11:44 AM
Points: 133, Visits: 282
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?
Post #1369561
Posted Sunday, October 7, 2012 4:23 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:47 AM
Points: 6,306, Visits: 13,605
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"
Post #1369581
Posted Sunday, October 7, 2012 8:41 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, August 8, 2014 11:44 AM
Points: 133, Visits: 282
Thanks Perry!
Post #1369600
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse