Create a cleanup job for the middle-tier database

Occasionally, when a service call is created in the host system but completed on a mobile device, records that are related to that service call do not get removed from the middle-tier database when the service call is completed.

To make sure these records are cleared out of the middle-tier database, you should set up the daily cleanup job. This job looks in the middle-tier database for records related to service calls that were closed or completed more than 14 days ago, and for task attachments that have no parent service call. Those records are removed from the middle-tier database during the next integration sync.

If more than 450 service calls are completed per day, we recommend that you work with WennSoft Support.

This job is automatically set up when you create a new middle-tier database in Signature MobileTech R7.0. However, if you are upgrading to Signature MobileTech R7.5 from a release prior to MobileTech R4.0 SP1, you need to manually create this cleanup job in MobileTech Administration.
When you create the cleanup job, it is automatically set up to run every four hours each day. To change the frequency or specify the time, change the schedule for the SQL Server Agent job. For more information, see the Microsoft SQL Server documentation.

1. In MobileTech Administration, choose Tools > Create Middle Tier Database Clean Up Job. The Create Cleanup Job page is displayed. 

   

   You must be a member of the SQL Server SysAdmin role to open this page.

2. Choose Close after the cleanup job is created.