Views: 1699
Number of votes: 5
Average rating:

Weird problem with scheduled jobs not running as expected

Two weeks ago I got an email from a customer that some data that was imported via a scheduled job seemed to be missing. So I logged into admin mode and checked the job history. And yes the job hadn't been run as it supposed to.I didn't think that much about it and settled for running it manually and changing the next scheduled date a couple of days ahead.

Since I was 100% sure this would be the end of the problem I didn't verify that the job actually did run on the new date which it didn't.

Hmm strange, and to make things even more strange I could see that other builtin jobs were running perfectly. 

I never found out what the problem were exactly but clearing the scheduld job- and log-table fixed the issue. Thanks to the support for the script.

If you run into this and want to run the script below remember to do a db backup (you never now) and note down how the scheduled jobs are configured so you can reconfigure them after clearing the tables.


delete [tblScheduledItemLog]
delete [tblScheduledItem]

Nov 16, 2016

( By Vincent, 11/17/2016 1:25:31 AM)

So, what's the root cause of this issue? Have you logged support ticket? 

( 11/17/2016 9:08:47 AM)

Yes I have a support ticket open but haven't got a response as to what can be the root cause. If / when I get that I will update the post.

Please login to comment.