Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: Monday, September 19, 2016 8:44 AM
Points: 157, Visits: 360
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


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Monday, September 26, 2016 11:57 PM
Points: 8,234, Visits: 16,383
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: Monday, September 19, 2016 8:44 AM
Points: 157, Visits: 360
Thanks Perry!
Post #1369600
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse