SQL Server Performance Forum – Threads Archive

Job history get cleaned up automatically

Hi Folks, My sql server is behaving strangly.The job history gets cleared automatically,I dont have a history clearing script or job in my enviorment.Can some one tell me how to invistigate this matter.

---

Is it in SQL 2000 or 2005? Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

---

Sql server does it automatically depends on the configuration of SQL Agent properties/Job system… MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

---

The default number of rows to retain in job history table is 1000 under SQLAgent properties, you can set it as you need and also set an appropriate size to the MSDB database. http://msdn2.microsoft.com/en-us/library/ms190956.aspx resizing. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

---

Its SQL 2005,and the situation is for all the jobs on this server.I cant find any error

---

Then check above link to resize it and also refer to the SQLAgent log. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

---

Are you sure no one cleaned up manually…
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

---

]]>