ReportServer Forum

unsi_2

Member

Registered: 2020-06-24

unstable script scheduler

hi, the script scheduler seems to be unreliable (RS3.7.0-6044)

i scheduled a script every hour, but for two ocassions stop working unexpectedily

for instance, it executed at 9:30 PM, but that was the last one, and if i check now the next scheduled executions show me times in the past :

reportserver$ scheduler listFireTimes 1...
Oct 14, 2021 10:30:00 PM
Oct 14, 2021 11:30:00 PM
Oct 15, 2021 12:30:00 AM
Oct 15, 2021 1:30:00 AM
Oct 15, 2021 2:30:00 AM
Oct 15, 2021 3:30:00 AM
Oct 15, 2021 4:30:00 AM
Oct 15, 2021 5:30:00 AM
Oct 15, 2021 6:30:00 AM
Oct 15, 2021 7:30:00 AM

in other occasion checking the listfirestimes, showed me for next execution 13:30 pm, instead of 13:30 am as should be

could be a way to fix this?

kind regards

eduardo

Administrator

Registered: 2016-11-01

Website

Re: unstable script scheduler

Hi unsi_2,

how exactly did you define the schedule for this script?

"but for two ocassions stop working unexpectedily" -> what happened exactly?

Regards,
Eduardo

unsi_2

Member

Registered: 2020-06-24

Re: unstable script scheduler

hi Eduardo

it was set:

scheduleScript execute script.rs "  " every hour at 30

It writes into database every time it executes.

With stop working unexpectedily i mean it didnt fire.

for instance, it executed last time at 9:30 PM, but looking next execution the following day, it still was to fire past executions:

reportserver$ scheduler listFireTimes 1...
Oct 14, 2021 10:30:00 PM
Oct 14, 2021 11:30:00 PM
Oct 15, 2021 12:30:00 AM
Oct 15, 2021 1:30:00 AM
Oct 15, 2021 2:30:00 AM
Oct 15, 2021 3:30:00 AM
Oct 15, 2021 4:30:00 AM
Oct 15, 2021 5:30:00 AM
Oct 15, 2021 6:30:00 AM
Oct 15, 2021 7:30:00 AM

In other occasion checking the listfirestimes, showed me for next execution 13:30 pm, instead of 13:30 am as it should be, so 12 expected executions were missing.

I have also observed strange behaviours like firing several consecutive times  when it shouldn't.

kind regards

eduardo

Administrator

Registered: 2016-11-01

Website

Re: unstable script scheduler

Hi unsi_2,

can you reproduce this by some test-case ? so we may take a look. With other words, if you create a test case two times in exactly the same way, does this happen both times ?

Regards,
Eduardo

unsi_2

Member

Registered: 2020-06-24

Re: unstable script scheduler

hi Eduardo

it is random, sometimes it seems that both schedulers (reports scheduling and script scheduler) are stuck in some way.
are they related?

is there a way that script schedules can be restarted?
so that
scheduler listFireTimes 1...
gets updated?

Regards