How to change schedule start times all at once. (215143)

Chat now with support

Return

Feedback submitted.

Was this article helpful?

[Select Rating]

Title

How to change schedule start times all at once.
Description

You want to shift all schedule start times but want to avoid manual changes. Can this be scripted?
Cause

This can be achieved with a SQL Query directly on the Identity Manager database.
Resolution

-- show the old/new StartTimes
select
StartTime as 'Old StartTime',
right(convert(char(16), dateadd(hh, 1, convert(datetime, StartTime, 114)), 121), 5) as 'New StartTime',
Frequency_Type,
FrequencySubType,
Frequency,
*
from DialogSchedule
where
Frequency_Type in ('Year', 'Month', 'Week', 'Day')
-- change them to the new time
update DialogSchedule
set StartTime = right(convert(char(16), dateadd(hh, 1, convert(datetime, StartTime, 114)), 121), 5)
where
Frequency_Type in ('Year', 'Month', 'Week', 'Day')
Please make sure to have a valid database backup available before running any SQL Queries.

Feedback submitted.

Was this article helpful?

[Select Rating]

Title