HI Gabud, Why not use the Archive feature on the Email Messages form? In the form set the Archive Type to "Delete from Source" and set a time like an escalation. In a case like this (3M records) first I find the date of the first record (e.g. 9 Dec 2007) and set up the qualification as 'Create Date' < (60*60*24*705). This is two years minus 25 days. Each day after the archive has run I subtract another 25-30 days until I get to the desired number of days which for me is 3 days. Nothing special about the 25-30 days, just like to do small batches. Once you get down to the desired level of days, you can almost forget that it runs.
You can run the Archive more then once a day but no less than once an hour. Archive won't start if the previous Archive is still running. FYI Mark ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Ex Soundgarden Sent: Tuesday, December 08, 2009 6:57 PM To: [email protected] Subject: safest and fastest way to delete AR Email records Hi All, I've been wandering around searching for some tips on how to delete 3 million records sitting in AR System Email Messages form. What I''m doing right now is just doing it by batch - deleting 10,000 records every now and then. From the past, I remember doing it directly in the database by re-creating the Email Messages table (which eventually dropped all the records). I had no problem with this. I just want to know if there are other ways to delete the records without going directly to the db? Thanks, Gabud _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ ________________________________ This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"

