0

In the Agent job view history of SQL Server, there are just limited log rows of o executed job. I want to see old executed job logs. Is there any way to see that?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
behzad
  • 194
  • 6
  • 21
  • The LDF file is the transaction logs of the database, the majority of which will be details of transactions that occured since the last transaction log backup (assuming you're using a full backup model). You don't use it to get the logs of the SQL Agent; that has it own log file(s). – Thom A Jan 01 '22 at 14:28
  • @Charlieface Thanks a lot. It was right what I want – behzad Jan 02 '22 at 06:04
  • You should have a button above to accept the duplicate, which will close the question and show this link in a banner at the top – Charlieface Jan 02 '22 at 06:08

1 Answers1

1

Is there any way to see that?

Job history is stored in MSDB, so on test server restore an old backup of MSDB.

David Browne - Microsoft
  • 80,331
  • 6
  • 39
  • 67