Solved

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

Posted on 2016-07-21
2
91 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 51

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

The New “Normal” in Modern Enterprise Operations

DevOps for the modern enterprise offers many benefits — increased agility, productivity, and more, but digital transformation isn’t easy, especially if you’re not addressing the right issues. Register for the webinar to dive into the “new normal” for enterprise modern ops.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL server 2014 replication error 20 41
TSQL XML Namespaces 7 24
sql server query 18 41
Update one table with results from another table in SQL 6 27
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

831 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