An automated process runs daily to delete outstanding requests from the push request queue on a Microsoft® SQL Server®. However, you can also delete requests manually on an adhoc basis as required.
- Perform one of these actions:
- If you are using the Microsoft SQL Server Enterprise Manager, navigate to Console Root\Microsoft SQL Servers\SQL Server Group\<BlackBerry_Configuration_Database_server>\Management\SQL Server Agent\Jobs.
- If you are using the Microsoft SQL Server Management Studio, navigate to SQL Server Agent\Jobs.
- If you are using an IBM® DB2® UDB server, create a custom job to purge IBM DB2 UDB push requests from the Configuration Database.
For simplicity, you can name the job after SQL Server processes. See step 2.
- Start the RIMPurgeMDSMsg<database_name> process.