topic Re: Daylight Savings with Scheduled Jobs in Alteryx Server Discussions

Daylight Savings with Scheduled Jobs

Treyson — Tue, 05 Nov 2019 19:04:00 GMT

Recently one of our partner's servers hit a snag during the switch this past weekend. All of the jobs that ran around the time where the clocks fell back ran but also stayed scheduled and then nothing ran the next day on the schedule. They were literally ahead of the schedule.

They rebooted the server and it reset everything, but I am curious if anyone else has seen this before because I have not.

Re: Daylight Savings with Scheduled Jobs

dorachen — Wed, 06 Nov 2019 22:06:10 GMT

We had the identical issue with our scheduled Server workflows. Thank you for posting your experience!

Here is the Alteryx Support reply:

There is a defect that has been created for this issue (DE22005) and has to do with how the new timezone feature handles Daylight Savings time changes. Our development team plans on introducing this fix in the next releases. I will associate the defect with this case so that when a fix is released for the issue you will receive an automatic email notification. Let me know if you have any questions.

Re: Daylight Savings with Scheduled Jobs

raychase — Sun, 10 Nov 2019 22:13:48 GMT

We experienced the same issue. It pertains to the 'LastRunDate' or 'NextRunDate' of a scheduled job falling within a time frame of ambiguity (12am-2am on the morning of a scheduled time change). Since this issue hasn't been formally resolved, a user could theoretically halt job processing on your server by scheduling a job during the next ambiguous time frame (12am-2am on March 8, 2020).

Let's hope Alteryx rolls out a fix ASAP.

Re: Daylight Savings with Scheduled Jobs

dorachen — Wed, 29 Jan 2020 00:01:15 GMT

From Support: This was fixed in the 2019.3 stable update as well as the 2019.4 release. It was not included within the release notes.

Re: Daylight Savings with Scheduled Jobs

levell_x_dunn — Wed, 11 Mar 2020 14:37:54 GMT

We are on 2019.4.8 and our schedules till failed and now won't come back up and it's still not working.

Re: Daylight Savings with Scheduled Jobs

TimN — Thu, 01 Oct 2020 17:22:20 GMT

Hi,

So if we move schedules out of that window we should be okay? Has this worked for you? We just ran into the problem and can't upgrade quickly (take at least a couple of weeks.)

We're looking for an interim solution. Also, does a reboot fix the issue?

Thanks,

Tim

Re: Daylight Savings with Scheduled Jobs

Treyson — Thu, 01 Oct 2020 22:43:09 GMT

If you can, just reboot the server. It will pick up any missed schedules.

If you are trying to get ahead of it, I can't answer sorry.

Re: Daylight Savings with Scheduled Jobs

TimN — Thu, 01 Oct 2020 23:26:05 GMT

Ray,

This helped we moved all schedules out of the window of 12am-2am to after 215AM. We also deleted any disabled schedules with the "bad" dates. We then restarted Alteryx service and that cleared up the issue.

Thanks Again,

Tim

Server Version 2019.3.2.15763