Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Job execute puzzle

Author  Topic 

ashish.johri
Starting Member

10 Posts

Posted - 2007-10-11 : 10:23:29
Hi,

Can I find out the user who has executed the job?

The result of query Q1) gives this information in the message column of the output.

Q1) select * FROM Msdb..sysjobhistory

Do we have any other table or SP from this information can be captured directly?

Regards,
Ashish Johri

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-10-11 : 23:39:48
Check job history, it'll tell who started the job.
Go to Top of Page
   

- Advertisement -