Create a Cleanup Job for the Middle-tier Database

Occasionally, when a service call, service appointment, or job appointment is created in the host system but completed on a mobile device, records that are related to the call or appointment do not get removed from the middle-tier database when the call or appointment 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 are 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.

• Service appointments that are before or after 14 days from the current date (based on the task date) or within 14 days with a status of CLOSED or RE-ASSIGNED.

• Job appointments that are before or after 14 days from the current date (based on the start date).

If more than 450 service calls and/or appointments are completed per day, we recommend that you contact 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. 

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

2. Select Close after the cleanup job is created.