Solved

Find which specific user created a SQL Agent Job in SQL Server

Posted on 2016-07-21
2
53 Views
Last Modified: 2016-07-21
Heyas,

Is there a method to find out who created an SQL Agent Job the actual username?

I am running SQL Server 2008

Any assistance is appreciated.

Thank you
0
Comment
Question by:Zack
2 Comments
 
LVL 49

Accepted Solution

by:
Ryan Chong earned 500 total points
ID: 41722286
try use:  suser_sname( server_user_sid )
select suser_sname( owner_sid ) owner_name, * from [msdb].[dbo].[sysjobs]

Open in new window

for more info:
SUSER_SNAME (Transact-SQL)
https://msdn.microsoft.com/en-sg/library/ms174427.aspx
0
 

Author Closing Comment

by:Zack
ID: 41722297
Thank for script, it gave exactly the info I wanted. Cheers
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Help in Copy Database Wizard From One SQL Server to Other SQL Server 10 28
Export import database 4 41
SQL Login 17 38
Sql Query with datetime 3 0
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now