Manually inserting records in ewait

I have a timer that sends folders back to the very first stage after 90 days of inactivity. The folders that were already sitting at the stage before I created the timer event do not have an ewait record - but I'd like to create some records to clean up these folders. After inserting the records in ewait, is there anything else I need to do in order for the engine to recognize that they have been put there and need to be processed?

Thanks

Find more posts tagged with

BPM

Comments

Jerome_Pearce

Some action needs to occur. The eWait table is not checked until the next action happens, or the engine is restarted.

Michael_Turek

It's not working for me for some reason. I inserted the record between two timer events that were about to go off - it complete ignored the record I created, but processed the other two.

insert into ewait (
eflagname, ewaittime, efolderid, 
emapname, eenginename, ethreadno, epriority, 
eflagfolder, eactionname)
select
' ', dateadd(minute, 5, getdate()), efolderid,
' ', ' ', 0, 0,
' ', 'return 90 day items'
from #expired_folders