Welcome to Port3101.org : Your BES Connection Mark forums read | View Forum Leaders
Port3101.org : Your BES Connection



Reply
LinkBack Thread Tools Display Modes
KB04426 - How to run Microsoft SQL Server maintenance jobs for the BB Config DB
 
  #1 (permalink)  
Old 09-12-2009, 12:23 PM
hdawg's Avatar
Proprietor
 
Join Date: Nov 2008
Posts: 2,257
Blog Entries: 147
Default KB04426 - How to run Microsoft SQL Server maintenance jobs for the BB Config DB

KB04426 - How to run Microsoft SQL Server maintenance jobs for the BlackBerry Configuration Database


Environment

  • BlackBerry® Enterprise Server version 4.0 and 4.1



Overview

Important: If the BlackBerry Configuration Database is hosted by a Microsoft® SQL Server™ 2005 Express edition, see KB14017.
In some environments, multiple transactions may cause the BlackBerry Configuration Database to increase in size. This can occur if the Microsoft SQL Server does not run BlackBerry Enterprise Server maintenance jobs automatically. By default, the BlackBerry Enterprise Server maintenance jobs should run automatically once a week. These jobs do not execute unless the SQLSERVERAGENT service is running.
To run the maintenance jobs, perform the following steps:
  1. Go to Control Panel > Administrative Tools > Services and double-click the SQLSERVERAGENT service. This opens the SQLServerAgent Properties dialog box.
  2. Click Start and wait until the following jobs complete:
    • RIMPurgeDeletedUsersBESMgmt
    • RIMPurgeHistoryBESMgmt
    • RIMPurgeMDSMsgBESMgmt (for BlackBerry Enterprise Server software version 4.1 only)
    • RIMPurgeMDSStatsBESMgmt (for BlackBerry Enterprise Server software version 4.1 only)
    • RIMPurgeWorkQueueBESMgmt
    Upon completion of the RIMPurgeDeletedUsersBESMgmt job, the BlackBerry Configuration Database retains entries from the last 30 days or the last 10,000 entries, and deletes all previous entries.
    Upon completion of the RIMPurgeHistoryBESMgmt job, the BlackBerry Configuration Database retains entries from the last 60 days or the last 10,000 entries, and deletes all previous entries.
    Upon completion of the RIMPurgeMDSMsgBESMgmt job, the BlackBerry Configuration Database deletes the old data from the push messages table and does not retain any old messages.
    Upon completion of the RIMPurgeMDSStatsBESMgmt jpb, the BlackBerry Configuration Database deletes the old statistical data for the BlackBerry® Mobile Data Service or BlackBerry® Mobile Data System (BlackBerry MDS) and does not retain any old statistics.
    Upon completion of the job for RIMPurgeWorkQueueBESMgmt, the BlackBerry Configuration Database retains entries from the last 15 days or the last 10,000 entries, and deletes the previous entries.
  3. From the Startup type drop-down list, select Automatic to allow the BlackBerry Configuration Database jobs to run at manageable sizes and consistent intervals.
Note: By default, the Startup type for the SQLSERVERAGENT service is set to Manual. If the Startup type is set to Automatic, all BlackBerry Enterprise Server maintenance jobs execute regularly, as shown in the following examples:
  • RIMPurgeDeletedUsersBESMgmt starts every week on Sunday at 2:00 AM
  • RIMPurgeHistoryBESMgmt starts every week on Sunday at 1:00 AM
  • RIMPurgeWorkQueueBESMgmt starts every week on Sunday at 2:00 AM
  • RIMPurgeMDSMsgBESMgmt starts every day at 3:33 AM
  • RIMPurgeMDSStatsBESMgmt starts every day at 2:22 AM
A job can be run at any time or the stored procedures that are called by these jobs can be executed manually.
For Microsoft SQL Server 2000
  1. In Microsoft SQL Enterprise Manager, go to the following folder and double-click Jobs. Microsoft SQL Servers\SQL Server Group\<BlackBerry_Enterprise_Server_name>\Management\SQL Server Agent
  2. Right-click the name of the job that needs to be executed and click Start Job.
If you do not have Microsoft SQL Enterprise Manager, perform the following steps:
  1. Open a command prompt.
  2. Type osql -E and press ENTER. The 1> prompt appears.
  3. The -E switch uses the Microsoft Windows® current account credentials to log in to the default BlackBerry Configuration Database. If you do not use the default database, add the -S switch to the end of the osql command line.
  4. If the Microsoft Windows account you are using does not have sufficient permissions, or you need to use an SQL account to log in, replace -E with -U -P , where is the SQL login name and is the account password.
  5. Type the following commands in the specified order: 1>use <database_name>

    where <database_name> is the name of the BlackBerry Enterprise Server database

    2>exec <stored_procedure_name> <days_retained>

    where <stored_procedure_name> is the name of the stored procedure called by the job you want to run, and <days_retained> is the number of days for which to retain entries.

    3> go

    4>quit
  6. See the Additional Information section for information on the equivalent commands.
  7. Close the command prompt window.



Additional Information

The following table lists osql commands that specify a stored procedure that can be used to run calls and the number of days to retain entries. The commands are entered at the 2> prompt.
Job Name Stored Procedure Name Default Days Retained Value
RIMPurgeDeletedUsersBESMgmt RemoveDeletedUsers 60
RIMPurgeHistoryBESMgmt RemoveOldHistoryRows 30
RIMPurgeMDSMsgBESMgmt RemoveMDSPushMsgs None
RIMPurgeMDSStatsBESMgmt RemoveOldMDSStats None
RIMPurgeWorkQueueBESMgmt RemoveOldWorkQueue 15
The following examples show osql commands that can be used:
2>exec RemoveDeletedUsers 30

2>exec RemoveOldHistoryRows 60

2>exec RemoveOldWorkQueue 15
The jobs without a Default Days Retained Value, as shown in the table above as None, do not have the function to retain any old information. Do not specify a day value for these jobs.
__________________
http://blog.port3101.org/hdawg/
Reply With Quote
Sponsored Links
Reply

Bookmarks

Thread Tools
Display Modes

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

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
KB14017 - Run Microsoft SQL Server maintenance using SQL Server 2005 Express hdawg Featured BlackBerry KB Articles 0 09-12-2009 12:22 PM
KB14047 - What are BlackBerry Enterprise Server software maintenance releases hdawg Featured BlackBerry KB Articles 0 08-23-2009 08:56 PM
KB04586 - BlackBerry Enterprise Server support for Microsoft Exchange Server 2003 SP2 hdawg Featured BlackBerry KB Articles 0 06-25-2009 11:16 AM
KB03633 - What are the required permissions in the Microsoft SQL Server hdawg Featured BlackBerry KB Articles 0 04-07-2009 05:22 PM
KB13573 - SyncServerState error during BlackBerry Enterprise Server maintenance Si Featured BlackBerry KB Articles 0 11-25-2008 10:48 AM


All times are GMT -4. The time now is 01:34 AM.
Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2018, vBulletin Solutions, Inc.


 

SEO by vBSEO 3.3.2 PL2