Avatar

Level 3

Thanks Amit, Inder & Craig for your responses.  Would appreciate if you can comment on,

 

If I'm not wrong, the naming convention for a workflow temp table comprise of wkf_<workflowID>  (or something similar).  If we can somehow have a javascript scanning through the database to identify workflow temp tables present for workflows that are missing/deleted, can't we drop all such workflow temp tables? Or as an alternative, a javascript for dropping workflow temp tables that are older than days (say a month, as I don't see any reason why anyone would want to preserve old table records).

 

Would there be any repercussion to having one these in built? 

 

CC: @Jonathon_wodnicki 

 

-wALF