Solved

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

Posted on 2016-07-21
2
197 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 52

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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

707 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