Forum Discussion

NickKroppe's avatar
NickKroppe
Contributor
2 years ago

Solution to Update Task Scheduler Start Times to Account for Daylight Savings

Hi,  This time of year we have the common maintenance point regarding needing to update task scheduler start times to account for daylight savings. It is expected for the platform to not automatica...
Extenders
JackLacava's avatar
JackLacava
Community Manager
2 years ago

Nice one, Nick!

For the curious, the core of the code looks like this:

Dim dmSchedItem As List(Of DataMgmtScheduleItemEx) = _
	DataMgmtScheduleWcf.GetScheduledJobs(dbConnFW, dbConnApp, False)

For Each schedJob As DataMgmtScheduleItemEx In dmSchedItem

	'adjust the start time based on what the user defines
	schedJob.DataMgmtScheduleItem.StartTime = _
		schedJob.DataMgmtScheduleItem.StartTime.AddHours(Convert.ToDouble(hourAdjustment))

	' Function SaveScheduledJob(dbConnFW As DbConnInfo,dbConnApp As DbConnInfo,isNew As TriStateBool)
	DataMgmtScheduleWcf.SaveScheduledJob( _
		dbConnFW, dbConnApp, schedJob.DataMgmtScheduleItem, TriStateBool.FalseValue)

Next

That surfaces an interesting API to DM jobs that can have interesting applications. Cheers!