asked
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!
If you view the job history from SSMS in the message it will say 'The job was stopped prior to completion by user xxx.'
select message,* from msdb..sysjobhistory hope it may help to you by
www.sqltechi.blogspot.in
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
Got it now: No name but a reason --> "The job was stopped prior to completion by Shutdown Sequence 0." here is the code I've used: SELECT job.name ,history.message ,history.run_status FROM msdb.dbo.sysjobs job JOIN msdb.dbo.sysjobhistory history ON job.job_id = history.job_id WHERE history.run_status = 3 ORDER BY run_date ,run_time DESC
I have modified the SQL below because you need the job outcome from step 0 not the step detail. select top 1 message, * from msdb.dbo.sysjobs job join msdb.dbo.sysjobhistory history on job.job_id = history.job_id where name = 'YourJob' and step_id = 0 order by run_date, run_time desc
14 People are following this question.
