August 25, 2003 at 3:47 pm
Do we need to delete old job history from system tables in MSDB?
I have not deleted this for a while. Now my jobs are not running automatically. They are running as long as I am kicking them manually.
Please help.
.
August 25, 2003 at 4:10 pm
sp_delete_backuphistory
this will delete all history older than a certain day. Before doing this, do a search to see what is the oldest backup you have. If you have 6 month history and you want to delete history older than 3 days, this will take long long time to run.
HTH,
August 25, 2003 at 10:40 pm
This didn't work for me. I guess only backup history will be delated by this procedure.
I have reduced the MAX rows, in the database Maintenance plan, then manually ran the job to get it cleared by the system itself.
.
August 26, 2003 at 6:39 am
Use sp_purge_jobhistory to purge the job history.
August 26, 2003 at 6:40 am
Good to know. Thank You.
.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply