• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 671
  • Last Modified:

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

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
Zack
Asked:
Zack
1 Solution
 
Ryan ChongCommented:
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
 
ZackGeneral IT Goto GuyAuthor Commented:
Thank for script, it gave exactly the info I wanted. Cheers
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now