Manually inserting records in ewait

Michael_Turek
Michael_Turek
in AppWorks #1

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

Tagged:

Comments

  • Jerome_Pearce
    Jerome_Pearce
    #2

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

  • Michael_Turek
    Michael_Turek
    #3

    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

     

     

Categories

image
OpenText CE Products
AppWorks
Gateway & Platform