search

rdesantis / hauldata

Database Process Automation made easy.
Apache License 2.0
1 stars 0 forks source link

TODAY EVERY ... FROM NOW ... intermittently fails to run #114

Closed rdesantis closed 5 years ago

rdesantis commented 5 years ago

The following schedule does not run the enclosed tasks most of the time. Occasionally it will run them. When it does, it never runs immediately:

ON SCHEDULE 'TODAY EVERY 5 SECONDS FROM NOW UNTIL 20 SECONDS FROM NOW'

To make It run immediately, you must use this syntax, but it still usually doesn't continue the schedule. It will run one and done.

ON SCHEDULE 'TODAY NOW, TODAY EVERY 5 SECONDS FROM NOW UNTIL 20 SECONDS FROM NOW'

rdesantis commented 5 years ago

Running it around 12:35 AM it mostly runs the schedule correctly, only occasionally failing. When run around 5:50 PM, it mostly failed.

rdesantis commented 5 years ago

Note that omitting FROM NOW has almost the same effect as including it, but when omitted the schedule has not been observed to fail. Only when including it has it been observed to fail.

rdesantis commented 5 years ago

Fixed per https://github.com/rdesantis/hauldata/commit/54c4d8ac6197277ac73aa9a971802353a6769838