<DIV>
<DIV>Hi Alon,</DIV>
<DIV> </DIV>
<DIV>Just thought I'd kick in my two cents :) Please excuse the double reply to this topic - I had the wrong subject in my previous post.</DIV>
<DIV> </DIV>
<DIV>I've had a quick look at program RSWWDHEX (the Deadline monitoring job) which I beleive is the relevant one for your proposed 2 year wait job. It seems to be very efficient and only reads table SWWWIDH using a date (with an index) to see which work items have reached their deadline. I can't see how you could write something that was much more efficient than this. </DIV>
<DIV> </DIV>
<DIV>The only caveat I add to this is that the deadline monitoring job typically runs several times an hour as opposed the 'nightly batch job' you referred to. I wouldn't be too concerned about this unless the volume of waiting workflows is huge.</DIV>
<DIV> </DIV>
<DIV>Cheers</DIV>
<DIV> </DIV>
<DIV>Peter Roehlen.</DIV><BR><BR>
<BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid"><mailto:araskin@3i-<br><mailto:araskin@3i-<br>Date: Thu, 5 May 2005 07:55:48 -0400<BR>From: "Alon Raskin" <araskin@3i-consulting.com><BR>To: "SAP Workflow Users' Group" <sap-wug@mit.edu><BR>Subject: 2 year wait vs Batch Report<BR><BR>Hi Everyone,<BR><BR>I would love to hear peoples opinions on this issue.<BR><BR>We have a situation where a workflow has to do update a field and then wait for 2 years before clearing that field. There are two possibilities to this issue.<BR><BR>1. Put in a 2 year wait step<BR>2. Terminate the workflow and run a nightly batch job which would query some table and determine if 2 years have passed and then reset the field accordingly.<BR><BR>Currently I am leaning towards option 1 as I really don't see a difference in option 1 and option 2. Ultimately they are all just batch jobs which check dates and then do some processing. The volumes!
here are
very low.<BR><BR>Your thoughts?<BR><BR>Alon Raskin<BR>e: araskin@3i-consulting.com <mailto:araskin@3i-consulting.com><BR>w: http://www.3i-consulting.com<BR>_______________________________________________<BR>SAP-WUG mailing list<BR>SAP-WUG@mit.edu<BR>http://mailman.mit.edu/mailman/listinfo/sap-wug<BR></BLOCKQUOTE></DIV></mailto:araskin@3i-consulting.com></mailto:araskin@3i-<br></mailto:araskin@3i-<br><p><br><hr size=1>
Find local movie times and trailers on <a href="http://au.rd.yahoo.com/mail/tagline/*http://au.movies.yahoo.com" target=_blank><b>Yahoo! Movies.</b></a><br>