BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 07-13-2006, 07:01 AM   #1 (permalink)
Knows Where the Search Button Is
 
Join Date: Mar 2006
Location: Sydney, Australia
Model: 8700
Carrier: Telstra
Posts: 34
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Frequency of SQL maintenance jobs

Please Login to Remove!

Hi,

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:

RIMPurgeHistoryBESMgmt
RIMPurgeDeletedUsersBESMgmt
RIMPurgeWorkQueueBESMgmt

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.

Thanks,

Chris
Offline  
Old 07-27-2006, 01:00 AM   #2 (permalink)
Thumbs Must Hurt
 
Join Date: Aug 2005
Model: 6230
Posts: 74
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

I've heard of some admins runing these nightly. If you leave the default day retainer as descirbed in the mentioned KB, you are really going to hurt anything. Worst case is that someone loses some email or reconciliation if their bb has been off for 15 days or more. To that I'd say tough sh*t. Messages are still on the desktop, and if you didn't use the BB for 15 days, then those messages weren't important.

What email platform do you have?
Offline  
Closed Thread


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On





Copyright 2004-2014 BlackBerryForums.com.
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.