Quartz Scheduled Job in Error State

Question

Hi,

I have two jobs scheduled with Quartz.

• One runs once per week.
• The second runs one per day, for three consecutive dates in the week.

I've noticed the following behaviour, but can't figure out what is going wrong.

• The first job sometimes just doesn't start at all. Before the scheduled start time, the TRIGGER STATE column is set to WAITING. After the start time, the TRIGGER STATE turns to ERROR. However, my job hasn't been invoked.

• The second job runs for the first day, but doesn't get triggered on the second day. I can see that the next run time has been updated in the NEXT FIRE TIME column of QRTZ TRIGGERS, but the TRIGGER STATE column is set to ERROR.

I've set the log4j level to DEBUG on org.quartz, but I can't see anything in the logs to indicate what is happening.

Has anyone any ideas what might be causing this and how to solve it?

This is with Quartz 1.5.2 and an Oracle database.

Thanks.