Where is agent job history saved in SQL Server.
I got agent job Jxxxxxx7A392AA9-8428-4BA3-B1CD-CB3B786CD7D0
on failure this is the history in Log File Viewer. Where is this saved in MSDB (which table).
Date 20/01/2011 10:30:02 AM
Log Job History (Jxxxxxx7A392AA9-8428-4BA3-B1CD-CB3B786CD7D0)
Step ID 1
Job Name Jxxxxxx7A392AA9-8428-4BA3-B1CD-CB3B786CD7D0
Step Name Register Job
Sql Severity 0
Sql Message ID 0
Operator Net sent
Retries Attempted 0
Executed as user:
(R) SQL Server Execute Package 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
value to M. Started: 10:30:02 AM
Finished: 10:30:04 AM Elapsed: 1.953
seconds. The package execution
failed. The step failed.
sysjobhistory. Note (from the MSDN link)
Data is updated only after the jobstep completes.
Need to take into account that the jobs history is not kept for ever, but it depends on how it's configured your SQL Agent. You can see how much history it keeps on SQL Agent - properties - history. So if your jobs will run and create new history records, you will lose current data.