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. The job will automatically 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.

To create a cleanup job for the middle-tier database:

1. In MobileTech Administration, select 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. Select Close after the cleanup job is created.