/
Automatically Reset Technician Starting Locations
Document toolboxDocument toolbox

Automatically Reset Technician Starting Locations

Owned by Kimberly Onnen
Last updated: Oct 25, 2024
2 min read

You can enable the ResetTechStartingLocations (Company DB Name) SQL job to automatically reset technicians' starting locations in SQL Server Management Studio (SSMS). The SQL job defaults to disabled. Users can still manually reset the starting locations from the Geocoding window. See Setting Up Geocoding for Technician Starting Locations window.

The job is set up to run every 8 hours, beginning at midnight. The default run times are midnight, 8 AM, and 4 PM to accommodate three shifts with a two-hour grace period at the end of each shift.  The ResetTechStartingLocations job's schedule can be edited. Shifts are defined and assigned to technicians in Signature. See Setting Up Technician Shifts and Setting Up Technicians. 

If a technician's shift is:

  • 7 AM to 3 PM: It is assumed they are working from 7 AM to 5 PM, so the 8 AM and 4 PM running of the job would not reset their starting location but the midnight run would.

  • 3 PM to 11 PM: It is assumed they are working from 3 PM to 1 AM so the 4 PM and midnight running of the job would not reset their starting location but the 8 AM run would.

  • 11 PM to 7 AM: It is assumed they are working from 11 PM to 9 AM so the midnight and 8 AM running of the job would not reset their starting location but the 4 PM run would.

If you are using Signature Telematics, do not enable the ResetTechStartingLocations (Company DB Name) SQL job. Telematics automatically updates the vehicle location.

Enabling the SQL Job

To enable the ResetTechStartingLocations SQL job:

  1. Launch SSMS.

  2. Expand SQL Server Agent and then expand Jobs.

  3. Double-click ResetTechStartingLocations (Company DB Name).

  4. On the General page, mark Enable.

  5. Click OK.

Editing the SQL Job Schedule

If you need to edit the SQL Job Schedule, you can do this from the Schedules page in the Job Properties. For example, if you only have one or two technician shifts, you may want to run the SQL job every 12 hours or if you only have one shift, you might want to run this once every 24 hours.

To edit the SQL Job Schedule:

  1. Launch SSMS.

  2. Expand SQL Server Agent and then expand Jobs.

  3. Double-click ResetTechStartingLocations (Company DB Name).

  4. On the Schedules page, double-click ResetTechStartingLocations (Company DB Name) 3 Times Daily.

  5. Edit the appropriate fields.

  6. Verify the Enabled checkbox is marked for the schedule.

  7. Click OK.