Who cancelled the job - SQL Server Forums

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

SQL Server Administration (2005)

Who cancelled the job

Author

Topic

CanadaDBA

583 Posts

Posted - 2010-03-16 : 12:41:08

SQL 2005
I have a job which failed last night. It has 3 steps. Step 1 ran successfully but for step two I see the following in the history:


Date                      3/15/2010 8:34:41 PM
Log                         Job History (Optimization Task)

Step ID                 2
Server                   PRD01
Job Name                            Optimization Task
Step Name                         MINE Tables
Duration                              13:42:40
Sql Severity                        0
Sql Message ID                 0
Operator Emailed                            
Operator Net sent                           
Operator Paged                                
Retries Attempted                          0

Message
Executed as user: DOMAIN\SQLAdmin. The step was cancelled (stopped) as the result of a stop job request.

Another DBA cancelled the job because it took 13 hours and didn't complete. But I don't see his name in teh history or the logs. How can I find out who cancelled a job?

Canada DBA

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources