Unable to Schedule Jobs

mroker · 2022-10-06T19:07:26+00:00

There was an error rendering this rich post.

Hi everyone, I can manually run a job which works, however when I schedule a job, it says that it executes however the job does not run and I don't see it in the UI. When I look at the viewer, I see the following error:

'Could not fix consecutive blocks of CRON schedule'

Does anyone know how to resolve?

Find more posts tagged with

Comments

Jmoreno

Adding a comment here to tag along with this issue as I am also getting the same issue as of maybe a week ago this started happening. Before it was running just fine.

McSQL

@mroker can you provide more details as to where this is happening?

Jmoreno

We reached out to domo support and they responded with:

Hi, we have a fix for the scheduling issue in workbench. It can be fixed by clearing the schedule (selecting manual run), saving, then setting a schedule again. There was an update to our CRON library for Daylight Savings Time . Please follow the instructions above to correct the issue. Thanks Domo Support

I have given that a try but will not know if all good until the next re-run which is in 2 hours for me. Will keep you all posted.

Jmoreno

Alright I come back with an update on my previous comment.

Their solution did not work for me ... but I have fixed my issue.

I had a group schedule with 18 jobs in it that all run in parallel. I figured maybe the load was too much on just one single group schedule. So what I did was I split it into 2 group schedules that run only a minute apart. All 9 jobs on each one still run parallel.

KEY NOTE: I noticed that when creating the group schedules there is a "Basic Schedule" and an "Advanced Schedule". I was trained to use the advanced one since that how things were being done here when setting jobs that have an interval refresh time like every 1 or 2 hours. Well I noticed the Basic Schedule has what I needed without going into the Advanced one, which is to run it every 2 hours. So I went ahead and set these 2 groups to run every 2 hours with the Basic Scheduler. In the last 50+ runs, all of them have been successful.

I hope this helps you out

TSIII

Is anyone still having this issue? We are seeing the CRON error at least once a day. The issue seems to have started when we setup group scheduler. I have contacted support and their recommendation was to upgrade to 5.2. We did this and updated our operating system on the server and we are still seeing the same error. I am following the advice above to change to the basic schedule but I really don't want to run these jobs on the weekend. Especially since we are on the consumption model.