Crontask or Escalation Will Not Run

Answer

When a Crontask or Escalation is not running correctly, it's usually due to a data error in the tasksscheduler table.


To clear this:

1. Set the escalation or crontask to inactive in the Escalations or Cron Tasks application.
2. From the back end, delete the records for this escalation or crontask only from the taskscheduler table:

delete from taskscheduler where taskname='ESCALATION.XXXXXX'

replacing the 'XXXXXX' with your escalation name.

or

delete from taskscheduler where taskname='crontaskname.instancename'

replace the 'crontaskname.instancename' with the crontask name and it's instance name.


3. Back to Escalations or Cron Tasks application.
4. Change the schedule time slightly and save the change. (Just by a minute is all that's needed to reset).
5. Optional - Change the schedule time back if you want or need to keep the schedule time exactly the same.
6. Activate the escalation or crontask.