BlackBerry Forums Support Community
              

Closed Thread
 
LinkBack Thread Tools
Old 07-13-2006, 06: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, 12: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

BLACK 3 POCKET SERVER WAITRESS WAIST APRON Chevron W/WO Name Lady Pizazz
$12.99
 BLACK  3 POCKET SERVER WAITRESS WAIST APRON Chevron  W/WO Name Lady Pizazz pictureServer Products DPD-86690 Dry Food Wall-Mount Dispenser, Double, 2 1 L Bottle
$282.21
Server Products DPD-86690 Dry Food Wall-Mount Dispenser, Double, 2 1 L Bottle pictureBlack Server 3 Pocket Waitress Waist Apron Cats Theatre W/WO Name Lady Pizazz
$12.99
Black Server 3 Pocket Waitress Waist Apron Cats Theatre W/WO Name Lady Pizazz pictureShoreTel UC-20 Unified Communications Server Password Locked
$59.0
ShoreTel UC-20 Unified Communications Server Password Locked pictureB & B Electronics 1 Port Mini Serial Server, RS-232, US PS - 1 x Network (RJ-45)
$39.99
B & B Electronics 1 Port Mini Serial Server, RS-232, US PS - 1 x Network (RJ-45) picture






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