Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ianbhenderson73
Starting Member
2 Posts |
 Posted - 2013-08-05 : 03:32:09
|
| Good morning allI've recently discovered that there's a stored procedure available in SQL 2008/2012 which automatically clears down the SQL Server Agent job histories, thus making it far quicker to get information on a job's historical performance.Can anyone tell me if there's a SQL 2005 version of the sp_syspolicy_purge_history procedure?ThanksIan HendersonBI Developer |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-08-05 : 04:23:08
|
| you've sp_purge_jobhistory available in sql 2005 for deleting history recordshttp://msdn.microsoft.com/en-us/library/ms175044(v=sql.90).aspx------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
|
|
|
Clearing old SQL Agent Job History