Re: Users - JOB _SANDBOX

Posted by Andrew Sykes on
URL: http://ofbiz.116.s1.nabble.com/Users-JOB-SANDBOX-tp137182p137211.html

Andrew,

If a job is completed, it'll have a FINISH_DATE_TIME.

So, something like this might help...
delete from JOB_SANDBOX where FINISH_DATE_TIME = "";

Service names are also logged in the JOB_SANDBOX, so if you know the
name of the offending service, perhaps this...
delete from JOB_SANDBOX where SERVICE_NAME like "nameOfOffendingService"

Bear in mind, I've never had to do this in production, so make sure you
back-up just in case this causes any unforeseen problems.
--
Kind Regards
Andrew Sykes <[hidden email]>
Sykes Development Ltd
http://www.sykesdevelopment.com

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users