Who stopped (canceled) my SQL Server Agent Job?

Question

question

eghetto asked Mar 21, '13

Who stopped (canceled) my SQL Server Agent Job?

Dear All, in my job (step) history a can see the following statement: ***"Executed as user: XX\\yyyy. The step was cancelled (stopped) as the result of a stop job request."*** Is there a way to find out who stopped this job? Thanks!

sql-server-2008-r2 sql-agent job job-history

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2013-03-21T08:46:10Z

tanglesoft answered Mar 21, '13

If you view the job history from SSMS in the message it will say 'The job was stopped prior to completion by user xxx.'

8

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

tanglesoft commented · Mar 21, 2013 at 08:48 AM

The information is recorded in msdb..sysjobhistory also

0 ·

eghetto tanglesoft commented · Mar 21, 2013 at 09:10 AM

Thanks - piece of code?

0 ·

askmlx121 commented · Mar 21, 2013 at 09:18 AM

select message,* from msdb..sysjobhistory hope it may help to you by www.sqltechi.blogspot.in

0 ·

tanglesoft commented · Mar 21, 2013 at 09:35 AM

If you execute select

0 ·

eghetto commented · Mar 21, 2013 at 09:36 AM

sorry, but the message column just contains "Executed as user: XX\yyyy. The step was cancelled (stopped) as the result of a stop job request." There is no information about the user who canceled the job. Or am I missing something...?

0 ·

tanglesoft commented · Mar 21, 2013 at 09:42 AM

select top 1 message from msdb.dbo.sysjobs job join msdb.dbo.sysjobhistory history on job.job_id = history.job_id where name = 'YourJobName' order by run_date, run_time desc

0 ·

Show more comments

question