Gabud,

Also consider deleting the records from the Email Error Logs form. If
you have 3 mil in the messages form, the error log is likely bloated as
well. 

The other question is do you need the e-mail messages to be stored in
the form for a period of time? If not (and you may already have done
this) you can configure the system to delete the e-mail after it has
been sent. This is done on the E-mail system Configuration form. 

 

Tauf Chowdhury | Forest Laboratories, Inc.

Analyst, Service Management

Mobile:646.483.2779

 

From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Brittain, Mark
Sent: Wednesday, December 09, 2009 8:48 AM
To: [email protected]
Subject: Re: safest and fastest way to delete AR Email records

 

** 

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.

_Platinum Sponsor: [email protected] ARSlist: "Where the Answers
Are"_ 

**********************************************************************
This e-mail and its attachments may contain Forest Laboratories, Inc. 
proprietary information that is privileged, confidential or subject to 
copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely 
for the use of the individual or entity to which it is addressed. If you are 
not the intended recipient of this e-mail, or the employee or agent responsible 
for delivering this e-mail to the intended recipient, you are hereby notified 
that any dissemination, distribution, copying or action taken in relation to 
the contents of and attachments to this e-mail is strictly prohibited and may 
be unlawful. If you have received this e-mail in error, please notify the 
sender immediately and permanently delete the original and any copy of this 
e-mail and any printout.

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"

Reply via email to