Asset Future Status duplication

(James) #1

[Squiz Matrix v5.4.3.1]
Hi, I think a trigger bug? might have caused hundreds of duplicate future status jobs to be added to our scheduled jobs. I’ve found a Content Container that has 2200 of these set against the future status:

Archived One Off at 10:05 on 4 Feb, 2020 Yes
Archived One Off at 10:05 on 4 Feb, 2020 Yes
Archived One Off at 10:05 on 4 Feb, 2020 Yes
Archived One Off at 10:05 on 4 Feb, 2020 Yes

Is there a way to get rid of them? I can delete them one by one but is there a quicker way. I’m worried the Scheduler won’t cope with thousands of duff records. Could I just delete the asset or will they remain in the scheduler?

James

(Bart Banda) #2

I’m pretty sure this should be able to get done via a script on the backend, not sure which one or how though. If you are a Squiz client, I suggest you send a support ticket in to get them to have a look and fix for you.