Port3101.org : Your BES Connection

Port3101.org : Your BES Connection (http://www.port3101.org/index.php)
-   Featured BlackBerry KB Articles (http://www.port3101.org/forumdisplay.php?f=3)
-   -   KB14017 - Run Microsoft SQL Server maintenance using SQL Server 2005 Express (http://www.port3101.org/showthread.php?t=1869)

hdawg 09-12-2009 12:22 PM

KB14017 - Run Microsoft SQL Server maintenance using SQL Server 2005 Express
 
KB14017 - Run Microsoft SQL Server maintenance using Microsoft SQL Server 2005 Express Edition


Environment

<content>
  • BlackBerry® Enterprise Server software versions 4.0 and 4.1
</content>
<hr class="section">
Overview

<content> Unlike other versions of Microsoft® SQL Server®, Microsoft SQL Server 2005 Express Edition does not support the SQLServerAgent service. Therefore, maintenance jobs created by the BlackBerry Configuration Database installer are not executed automatically. This could affect the state of the Blackberry Configuration Database. For more information on performing BlackBerry Configuration Database maintenance, see KB04426.
To work around the SQLServerAgent service limitation, create a batch file that will use the Task Scheduler of Windows® to execute weekly maintenance jobs. The following is an example of the commands used in the batch file:
@ ECHO OFF

REM *****************************************************

REM * Batch File Used To Execute SQL Stored Procedures *

REM * To Maintain A BlackBerry Configuration Database *

REM *****************************************************

CLS

REM *****************************************************

REM * This Process Is Called By Windows Automated Task *

REM * Scheduler Nightly *

REM *****************************************************

CLS

call osql -E -d BESMgmt -Q "exec RemoveDeletedUsers 30"

call osql -E -d BESMgmt -Q "exec RemoveOldHistoryRows 60"

call osql -E -d BESMgmt -Q "exec RemoveOldWorkQueue 15"

CLS

REM *****************************************************

REM * End of Database Maintenance *

REM *****************************************************
</content>
<hr class="section">
Additional Information

<content> BlackBerry Enterprise Server software version 4.1 Service Pack 5 (4.1.5) does not contain the RemoveDeletedUsers stored procedure, so this command will fail.
</content>


All times are GMT -4. The time now is 01:40 AM.

Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2019, vBulletin Solutions, Inc.


SEO by vBSEO 3.3.2 PL2