CODEWITHSUNDEEP
sql-server
asmgx
asmgx

Reputation: 8034

Longer History of SQL Server Jobs

When I check the SQL Server job it only shows for short period of time like few weeks back only

is there any way I can keep the job history for much longer period

enter image description here

Upvotes: 0

Views: 1983

Answers (1)

ZLK
ZLK

Reputation: 2884

This has to do with History settings in SQL Server Agent.

In the History tab of the Properties of your SQL Server Agent, you have the option of limiting job history size by rows (by individual job and by overall amount of rows) as well as choosing whether to delete history after a certain amount of time.

Upvotes: 3

Related Questions