07-13-2006, 06:01 AM
Knows Where the Search Button Is
Join Date: Mar 2006
Location: Sydney, Australia
Post Thanks: 0
Thanked 0 Times in 0 Posts
| | Frequency of SQL maintenance jobs
Please Login to Remove!
As part of some troubleshooting with RIM and Telstra today, we were told to run the weekly scheduled jobs on the SQL server manually.
RIM referred to this article: KB-04426.
Running these jobs helped resolve the activation issues we were having and the recommendation from RIM at the end of the call was that we should look to run these jobs daily rather than weekly.
Does anyone here have any experience of running these jobs daily:
Is so, are there any pros and cons? Our DBA will likely complain about running these frequently so I would like to be able to refer to other people that have experience.