View Single Post
  #1 (permalink)  
Old 09-12-2009, 12:22 PM
hdawg's Avatar
hdawg hdawg is offline
Proprietor
 
Join Date: Nov 2008
Posts: 2,257
Blog Entries: 147
Default 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

  • BlackBerry® Enterprise Server software versions 4.0 and 4.1



Overview

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 *****************************************************



Additional Information

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.
__________________
http://blog.port3101.org/hdawg/
Reply With Quote
Sponsored Links