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
ZackGeneral IT Goto GuyAsked:
Who is Participating?
 
Ryan ChongConnect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.