Per Nergård
Nov 16, 2016
  1821
(5 votes)

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.

ALTER TABLE tblScheduledItemLog NOCHECK CONSTRAINT ALL
ALTER TABLE tblScheduledItemLog CHECK CONSTRAINT ALL

delete [tblScheduledItemLog]
delete [tblScheduledItem]

Nov 16, 2016

Comments

Vincent
Vincent Nov 17, 2016 01:25 AM

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

Nov 17, 2016 09:08 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.
Latest blogs
Plug-in manager is back in CMS 12

Plug-in manager is back in the UI, what is it and how can i use it?

Luc Gosso (MVP) | Oct 6, 2022 | Syndicated blog

Display Child Pages in Content Delivery API Response

The below example will implement an instance of IContentConverterProvider to customise the serialisation of PageData and output child pages in the...

Minesh Shah (Netcel) | Oct 4, 2022

Bring the Report Center back in Optimizely CMS 12

The Report Center has been a part of Optimizely CMS since its first debut in version 5R2 in 2008, but in CMS 12, it's removed! Don't despair! Make...

Tomas Hensrud Gulla | Oct 4, 2022 | Syndicated blog

Customizing Property Lists in Optimizely CMS

Generic property lists is a cool editorial feature that has gained a lot of popularity - in spite of still being unsupported (officially). But if y...

Allan Thraen | Oct 2, 2022 | Syndicated blog

Optimizely names Luminary Senior Developer, Ynze Nunnink, OMVP

Luminary Senior Developer and Optimizely Lead, Ynze Nunnink has secured the coveted position of Optimizely MVP. Earning a Platinum badge for his...

Ynze | Oct 2, 2022 | Syndicated blog

Content Delivery API – The Case of the Duplicate API Refresh Token

Creating a custom refresh provider to resolve the issues with duplicate tokens in the DXC The post Content Delivery API – The Case of the Duplicate...

David Lewis | Sep 29, 2022 | Syndicated blog