Clearing old SQL Agent Job History

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.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Clearing old SQL Agent Job History

Author

Topic

ianbhenderson73
Starting Member

2 Posts

Posted - 2013-08-05 : 03:32:09

Good morning all

I'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?

Thanks

Ian Henderson
BI 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 records

http://msdn.microsoft.com/en-us/library/ms175044(v=sql.90).aspx

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources