Difference between revisions of "Workaround for Mis-scheduling Caused By Daylight Saving Issue"
(Created page with "'''Workaround for Mis-scheduling Caused By Daylight Saving Issue''' '''Problem''' There is an issue whereby Supportworks tasks, calls and reports scheduled prior to a daylig...") |
|||
| (7 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
'''Problem''' | '''Problem''' | ||
| Line 7: | Line 5: | ||
'''Solution''' | '''Solution''' | ||
| + | |||
The workaround for this issue entails following either of the procedures given below, depending on | The workaround for this issue entails following either of the procedures given below, depending on | ||
whether the clocks have moved forward or back. | whether the clocks have moved forward or back. | ||
| + | |||
'''If Clocks Have Moved Forward''' | '''If Clocks Have Moved Forward''' | ||
| − | 1. Run the Interactive SQL utility supplied with Supportworks by selecting Start > All Programs > | + | 1. Run the Interactive SQL utility supplied with Supportworks by selecting Start > All Programs > Hornbill Core Services > Interactive SQL. |
| − | Hornbill Core Services > Interactive SQL. | ||
2. In the command window, enter the following SQL statements: | 2. In the command window, enter the following SQL statements: | ||
| − | use sw_systemdb; | + | use sw_systemdb; |
| + | |||
| + | update system_scheduledcalls set schtime = schtime - 3600; | ||
| − | update | + | update system_scheduledjobs set nexttime = nexttime - interval 1 hour; |
| − | + | exit | |
| − | |||
'''If Clocks Have Moved Back''' | '''If Clocks Have Moved Back''' | ||
| − | 1. Run the Interactive SQL utility supplied with Supportworks by selecting Start > All Programs > | + | 1. Run the Interactive SQL utility supplied with Supportworks by selecting Start > All Programs > Hornbill Core Services > Interactive SQL. |
| − | Hornbill Core Services > Interactive SQL. | ||
2. In the command window, enter the following SQL statements: | 2. In the command window, enter the following SQL statements: | ||
| − | use sw_systemdb; | + | use sw_systemdb; |
| − | update system_scheduledcalls set schtime = schtime + 3600; | + | update system_scheduledcalls set schtime = schtime + 3600; |
| − | update system_scheduledjobs set nexttime = nexttime + interval 1 hour; | + | update system_scheduledjobs set nexttime = nexttime + interval 1 hour; |
| − | exit | + | exit |
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