Difference between revisions of "Workaround for Mis-scheduling Caused By Daylight Saving Issue"
(One intermediate revision by the same user not shown) | |||
Line 12: | Line 12: | ||
'''If Clocks Have Moved Forward''' | '''If Clocks Have Moved Forward''' | ||
− | + | 1. Run the Interactive SQL utility supplied with Supportworks by selecting Start > All Programs > Hornbill Core Services > Interactive SQL. | |
− | + | 2. In the command window, enter the following SQL statements: | |
− | |||
use sw_systemdb; | use sw_systemdb; | ||
Line 27: | Line 26: | ||
'''If Clocks Have Moved Back''' | '''If Clocks Have Moved Back''' | ||
− | + | 1. Run the Interactive SQL utility supplied with Supportworks by selecting Start > All Programs > Hornbill Core Services > Interactive SQL. | |
− | + | 2. In the command window, enter the following SQL statements: | |
− | |||
use sw_systemdb; | use sw_systemdb; |
Latest revision as of 14:09, 23 August 2016
Problem
There is an issue whereby Supportworks tasks, calls and reports scheduled prior to a daylight-saving clock-change trigger one hour earlier or later than expected after the change.
Solution
The workaround for this issue entails following either of the procedures given below, depending on whether the clocks have moved forward or back.
If Clocks Have Moved Forward
1. Run the Interactive SQL utility supplied with Supportworks by selecting Start > All Programs > Hornbill Core Services > Interactive SQL. 2. In the command window, enter the following SQL statements:
use sw_systemdb;
update system_scheduledcalls set schtime = schtime - 3600;
update system_scheduledjobs set nexttime = nexttime - interval 1 hour;
exit
If Clocks Have Moved Back
1. Run the Interactive SQL utility supplied with Supportworks by selecting Start > All Programs > Hornbill Core Services > Interactive SQL. 2. In the command window, enter the following SQL statements:
use sw_systemdb;
update system_scheduledcalls set schtime = schtime + 3600;
update system_scheduledjobs set nexttime = nexttime + interval 1 hour;
exit