Hi Guys,
Does anyone know how the reporting services temp tables cleanup happens?
Is it an epicor app server thing or a sql scheduled agent or a reporting services thing?
I have a heap of old tables that need to be removed and I just had sql almost lock up because it was trying to purge old tables.
I can’t find anything on the epicor support portal on how it’s setup 
Cheers
P
You did not specify versions. This area has an important patch to do a better algorithm for cleaning up. The cleanup up job is in Task Agent. The framework has an internal hook to get kicked by task agent - a few background efforts do this.
If Task Agent has been turned off for a long time and / or you have a long archive value in the print job, this can happen. You can see this discussion if you search around a few threads up here.
As @Bart_Elia mentioned version matters on this specific behavior.
and various other behaviors as we tweaked the logic between those releases.
Thanks Bart and Nathan,
I am on 10.1.400.21 upgrading to 10.1.600.something hopefully soon.
I will browse the other threads thanks