[Building Sakai] anybody know how to clear a stuck quartz job? [EVALSYS]

[Cris J Holdorph]

 From another project (not sakai) a friend has done this with quartz and 
had it work.  It should be done with great caution, but if you're 
wanting to try it out...

update qrtz_triggers set trigger_state = 'MISFIRED' where trigger_name 
in ('TRIGGER_NAME');
delete from qrtz_fired_triggers where trigger_name = 'TRIGGER_NAME';
triggers set trigger_state = 'WAITING' where trigger_name = 'TRIGGER_NAME';

---- Cris J H

(special thanks to the person I asked this morning.  I'll leave his name 
out of this, so he doesn't receive unsolicited emails)

On 06/18/2012 09:59 AM, Charles Hedrick wrote:
> We're not getting emails sent by EVALSYS. I believe the problem is that Quartz is stuck. QRTZ_FIRED_TRIGGERS shows org.sakaiproject.component.app.scheduler.ScheduledInvocationManagerImpl.runner executing, with the fired time not changing. Is there a way to clear this? Can I just clear the fired triggers table, or do we need something more?