Hi... Thought I would throw a similar idea into the mix: use a control table to hold one of the parameters in the query.
You have form A with millions of rows (that's a lac, right?), and you want to archive the oldest of these. In another table, form B, create one row with a date field. Initially set that date to be the very oldest record's submit date. Join this form to your form A so that you can see the date field in form B and the submit date and request ID of form A. Call this form C. Create one escalation which runs against form C every 30 minutes and looks for records older than the date field. If there are any records, perform the DSO operation on the form A record. If there are NO records, use an else action in the escalation to add some number of seconds - say 14400 for 4 hours worth - to the date field in form B. Make sure you add some limit to the else action so that you don't start archiving more recent records that you want - 2009 or 2010 or whatever. You could also make a max date field in form B and use that as a limit. But when this is set up, the escalation runs every 30 minutes and DSO's at most 4 hours worth of tickets, then basically does nothing for about an hour except to change the criteria for the next run. Overall load on the system is modest because of the chunking, and the escalation gets out of the way to allow other processes to run. All of the other suggestions are quite useful - a separate escalation pool, more escalation threads, time restrictions on when the escalation runs, using indexed criteria, etc. You could also run the escalation more or less often, change the added seconds and so forth to get the balance right. Hope this helps... Doug (no, the other, other Doug) -- Doug Blair +1 224-558-5462 Sent from my iPad Air Auto-corrected typos, misspellings and non-sequiturs are gratefully attributed to Steve Jobs :-) > On Sep 9, 2014, at 8:54 AM, Ken Pritchard <[email protected]> wrote: > > I have what I call a diagnostic form where I create a record for the form / > query I want to check the number of records on. An escalation runs > periodically to do the query needed and then I move the $LASTCOUNT$ keyword > into a field on that form. The count can then be emailed or acted on by > filters if it's over a threshold (another field on the diagnostic form). > > Just my way of doing it without needing additional software. > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[email protected]] On Behalf Of William Rentfrow > Sent: Tuesday, September 9, 2014 8:28 AM > To: [email protected] > Subject: Re: Escalation qualification : DSO > > I'm not sure what sort of problem you are having at the DB level, but have > you tried putting this escalation into its own escalation pool? > > I'd give that a try and change it to run every 24 hours instead of every 30 > minutes. > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[email protected]] On Behalf Of MalviyaSaurabh > Sent: Tuesday, September 09, 2014 12:49 AM > To: [email protected] > Subject: Re: Escalation qualification : DSO > > Thanks for all your reply. > One more clarification which I am seeking out is that my escalation runs on > every 30 mins, and I can see records coming into the DSO pending queue in > the DSO Pending form, I would want to know from where i can get to how many > records are qualified in each execution of this escalation. From my manual > analysis of Pending form, after an execution the number of records in DSO > Pending form reaches a maximum and then the records goes down to zero as it > gets services by DSO. > > Also if I have to get the same functionality via rrrchive tool (i.e. > automate restricted qualification to new 500 records in ( 'Ticket Closed > Date' <= "2/28/2009 11:59:59 PM") AND ( 'Status' = "Closed") AND ( 'Ticket > Closed Date' >= "1/1/2009 12:00:00 AM") qualification) what parameter I > would be using. > > > qual = ( 'Ticket Closed Date' <= "2/28/2009 11:59:59 PM") AND ( > 'Status' = "Closed") AND ( 'Ticket Closed Date' >= "1/1/2009 12:00:00 AM") > transfertype = MOVE > > Will using below help in my case or do I have to chose any other parameter. > Please help. > multientrychunksize = 500 > > > Regards, > Saurabh > > > > > > -- > View this message in context: > http://ars-action-request-system.1.n7.nabble.com/Escalation-qualification-DS > O-tp118847p118864.html > Sent from the ARS (Action Request System) mailing list archive at > Nabble.com. > > ____________________________________________________________________________ > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers > Are, and have been for 20 years" > > ----- > No virus found in this message. > Checked by AVG - www.avg.com > Version: 2014.0.4765 / Virus Database: 4015/8175 - Release Date: 09/08/14 > > ____________________________________________________________________________ > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers > Are, and have been for 20 years" > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
