|
My job history appears to be large, how do I clear it? Can I limit it's growth?
(comments are locked)
|
|
Clearing: SQL Server Agent > Jobs > Select the Job > Right mouse click (View History) > Highlight one or more log file summary from the list > Delete Limiting the growth: SQL Server Agent > Properties > History > Automatically remove agent history older than …
(comments are locked)
|
|
You can also call the stored procedure sp_purge_jobhistory Better still, schedule it to run periodically and keep things clean.
Oct 30 '09 at 02:28 PM
Raj More
(comments are locked)
|
Your answer
Its quite important to do this. MSDB lacks indexes in may places and keeping the tables small can help improve performance of tools accessing items such as job history.