Need to find user accounts that are running jobs

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server Newbies » Need to find user accounts that are running...

Need to find user accounts that are running jobs

Rate Topic

Display Mode

Topic Options

Author

Message

jdbrown239

Posted Sunday, October 07, 2012 12:42 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 11:35 AM
Points: 112, Visits: 212

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

Perry Whittle

Posted Sunday, October 07, 2012 4:23 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 2:02 PM
Points: 5,201, Visits: 11,149

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" Wink

Post #1369581

jdbrown239

Posted Sunday, October 07, 2012 8:41 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 11:35 AM
Points: 112, Visits: 212

Thanks Perry!

Post #1369600

« Prev Topic | Next Topic »

Permissions