Where is the agent job history stored in SQL Server.
I got an agent job Jxxxxxx7A392AA9-8428-4BA3-B1CD-CB3B786CD7D0
on failure, this is the story in Log File Viewer. Where is it stored in MSDB (which table).
Date 20/01/2011 10:30:02 AM
Log Job History (Jxxxxxx7A392AA9-8428-4BA3-B1CD-CB3B786CD7D0)
Step ID 1
Server HTS0470
Job Name Jxxxxxx7A392AA9-8428-4BA3-B1CD-CB3B786CD7D0
Step Name Register Job
Duration 00:00:03
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
Run as user: Hxxx \ HSSSQLAPPService. Microsoft (R) SQL Server Run Batch Utility Version 10.0.2531.0 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 10:30:02 AM DTExec: Could not be set \ Package.Variables [User :: jobType] .Properties [Value] Value for M. Started: 10:30:02 AM Ended: 10:30:04 am Expired: 1.953 seconds. Package execution failed. Failed to complete the step.
source