On Sql server 2005 & 2008, we are getting only like 4-5 days worth for Job History Retention.
But we need like 4 weeks of SQL Agent Job History Retention.
I am doing like going SSMS --> SQL Server Agent Properties --> history--> enabling automatically remove agent history older then 4 weeks-> click OK.
again if I open the properties. I don't see the enabled automatically remove agent history older then 4 weeks.
what was the issue? what should I must do set my history for 4 weeks.