09-12-2009, 12:22 PM
|
 |
Proprietor
|
|
Join Date: Nov 2008
Posts: 2,238
|
|
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/
The views expressed by me on Port3101 and its affiliated sites are my own and do not necessarily reflect the views of my employer.
|
Linear Mode
