SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 07:08 PM
| ||||
| ||||
 Scheduled Job History Is there a way to increase the number of records preserved in job history? I have 82 jobs on my box, 30 of them run every 20 minutes for 23 hours a day, every 30 days. Another 30 run once, every 30 days. The system seems to have a limit of 50 history records for any job that hasn't run since yesterday and purges all history records if the job is more than a week old. I didn't know if there might be a configuration record buried in MSDB or somewhere else that would allow me to increase this size or perhaps a system SP that prunes job history that I could modify. It isn't critical as the system is set to notify me when jobs fail, but still, I'd like to be able to look at a given day and verify that everything went normally.      |
|
02-28-2008, 07:08 PM
| ||||
| ||||
| Re: Scheduled Job History "P.D.N. Tame" <wwphx@hotmail.com> wrote in message news:bcc5d277.0312090628.5061b581@posting.google.c om... > Is there a way to increase the number of records preserved in job > history? I have 82 jobs on my box, 30 of them run every 20 minutes > for 23 hours a day, every 30 days. Another 30 run once, every 30 > days. The system seems to have a limit of 50 history records for any > job that hasn't run since yesterday and purges all history records if > the job is more than a week old. I didn't know if there might be a > configuration record buried in MSDB or somewhere else that would allow > me to increase this size or perhaps a system SP that prunes job > history that I could modify. > > It isn't critical as the system is set to notify me when jobs fail, > but still, I'd like to be able to look at a given day and verify that > everything went normally. In Enterprise Manage, right-click SQL Server Agent, then pick Properties, Job System, and set the history options as you want. You can also use sp_set_sqlagent_properties, but this procedure isn't documented, so it may not be the best way to go. Simon |
Linear Mode
