update SmartConnect Table
thanks for the question.
You had opened a support case for this and we took a look.
We found that the issue is that the tsql script worked fine. But the issue is that after you are Map task runs and updated the ScheduleMaster, then the eOne Scheduler comes behind it and sets it to the next scheduled time overwriting your own.
You were able to get around it by updating it in a different map.
The only solution I can see otherwise is to use a db trigger on the table itself and have it reset the datetime to whatever you need it to be since that would run just after the scheduler set it to the next expected datetime.