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 advanceOn 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
]]>