SQL Server Performance Forum – Threads Archive

Job History

How can I change the settings in my job history so as to see more, because I could previously check job history as long as weeks but now i only get history for days precisely three days or less. thanks in advance

---

On EM expand Management, right-click SQL Server Agent, and then click Properties.
Click the Job System tab, and then select Limit size of job history log check box. _________
Satya SKJ

---

From SQL Query analyzer, you can look into msdb..backupset table to see all the job history that SQL Server is maintaining. Gaurav

---

I believe sp_help_jobhistory is more elegant. _________
Satya SKJ

---

]]>