Posted by MickC on June 26, 2014 at 5:23am
Does anyone know how to reset / empty cron?
I've got a bad Notifications job stored in cron which I want to purge before rerunning cron.
Deleting cron_semaphore and cron_last from variables, resetting cache doesn't work.
There must be either a database record/s or file with the cron 'queue' somewhere.
Can't seem to find any issues/docs/instructions for this - a couple of issues but they only repeat the above.
Can anyone help?
Thanks

Comments
queue table?
The answer would lie in the notifications module. I've not got a copy running in D7, but in d6 there is a notifications_queue table. Might be worth a look.
Also, have you checked the drupal queue table?
https://www.drupal.org/project/cron_debug might also be helpful.
Thanks tripper54 -
Thanks tripper54 - notifications_queue looks like it. 61,000+ records, resulting from an email loop.
Backed that up and truncated the table.
Cron running again and looks like its going to be OK.
Thanks for your help - closing unless something else crops up...