Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Version History

« Previous Version 2 Next »

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. 

 Click to view examples.

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.

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.

  • No labels