Re: [jbpm-dev] [jbpm 5.2] delete task rows when a process ends

I created a stored procedure scheduled with a job that delete all tasks data related to a non existing process instance (it runs once a day) I think anyway the problem must be faced because when you handle many process instances every day your JBPM database will grow fast and it becomes an issue in production. Thanks, Giovanni ----- Original Message ----- From: "Mauricio Salatino" <salaboy(a)gmail.com&gt; To: "Giovanni Marigi" <gmarigi(a)redhat.com&gt; Cc: jbpm-dev(a)lists.jboss.org Sent: Monday, March 12, 2012 4:21:50 PM Subject: Re: [jbpm-dev] [jbpm 5.2] delete task rows when a process ends Not really. usually BPMS are good to keep track about that the work that has being done. The human task server will keep track and record all your human activities. If you want to do some clean ups you will need to write the right sql queries against the human task server schemas On Mon, Mar 12, 2012 at 2:43 PM, Giovanni Marigi < gmarigi(a)redhat.com > wrote: Hi, currently when a process instance ends, every task linked to this process (even if in state Completed) is not deleted from DBMS. Is there a way to change this behaviour and delete all task data persisted on DBMS when a process ends? Thanks, Giovanni -- Giovanni Marigi Red Hat - JBoss Consultant - email: gmarigi(a)redhat.com Mobile: +39 3423175986 Office: +39 0687502315 Red Hat Italy Via Andrea Doria 41m 00192 Roma - Italy www.redhat.com Prima di stampare, pensa all'ambiente ** Think about the environment before printing _______________________________________________ jbpm-dev mailing list jbpm-dev(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/jbpm-dev -- - MyJourney @ http://salaboy.wordpress.com - Co-Founder @ http://www.jugargentina.org - Co-Founder @ http://www.jbug.com.ar - Salatino "Salaboy" Mauricio - -- Giovanni Marigi Red Hat - JBoss Consultant - email: gmarigi(a)redhat.com Mobile: +39 3423175986 Office: +39 0687502315 Red Hat Italy Via Andrea Doria 41m 00192 Roma - Italy www.redhat.com Prima di stampare, pensa all'ambiente ** Think about the environment before printing