Tadeu, You could schedule an Archive on the Server Event form and just delete records without putting them into an Archive form.
Since you have a large number of records, you could do this in batches to delete smaller chunks at a time and this also could be done after hours... Mike -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tadeu Augusto Dutra Pinto Sent: Thursday, January 10, 2008 7:13 AM To: arslist@ARSLIST.ORG Subject: RES: Delete Records of Alert Events Complementing... I'm using: ARS Server: ARS 7.0.01 Patch 004 - Operational System: AIX 5.3 ARS User: ARS 7.0.00 Patch 001 - Operation System: Windows XP Database: Oracle 9i ________________________________ De: Action Request System discussion list(ARSList) em nome de Tadeu Augusto Dutra Pinto Enviada: qui 10/1/2008 10:59 Para: arslist@ARSLIST.ORG Assunto: Delete Records of Alert Events ** Hello for all, How can I clean up records from a table that growths abnormaly?? I'm facin' a serious problem with "Alert Events" table. Since 2004 it's been growing without control... Nowadays, this table has around 7 GB... I want to know if have a way that I can delete all records of this table with a security mode (not crashing the server)... Could it be with Escalations? If Yes, how? With Application-Delete-Entry? Application-Query-Delete-Entry?? I thought in a way to delete records based in a range of date... Like taking the date of First record saved in this table and going to deleting month by month (in a range of a month/day)... Is it possible?? Gimme your suggestions, please! Thankx-in-advance... Regards... P.S.1: I have knowledge tha exists the Escalation "CleanUpAlertEvents" but I think that this way will crash my ARS server if I runs it... P.S.2: I have another tables like that... but Alert Events is the greater... Tadeu Augusto Dutra Pinto ----------------------------------------------------------------- IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing ----------------------------------------------------------------- Confiabilidade, Inovação e Qualidade em T.I. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
