Re: [Microsofts_C_Sharp] Batch Processing !!!

Mon, 17 Oct 2005 02:21:21 -0700

Hi All,
 
If I were you, I will perform the following steps to do the job in a professional way. For this I prefer BI logic (i,e At Database level)
 
1. Make sure that the main table has a Column called LoggedOn, and make is 'datetime' format.
2. Now create a SQL Agent job to run automatically at Weekly or daily on some time I choose (One week at Friday Night 11:55 PM) and Check for >= 40 and delete those rows.
 
This is the best approach I can suggest.
 
Krishnam Raju Bhupathiraju
Infosys Technologies,
India

FREEMAN <[EMAIL PROTECTED]> wrote:
hi,
i think you must have trigger on no.days, if no.days exceeds limits(40 in your case), you the trigger.
another solution, say you have column called No.Days.so, it counts from system untill it found that no data has been no entered, so you make check constraint in that column and delete if the check constrain on No.days Column exceeds 40.
i hope it will help..

Mohamed Nabil <[EMAIL PROTECTED]> wrote:
hi all,
 
i want to ask about how to implement batch processing in a web application (ASP.NET)
 
for example:
if I have forums application, I want to delete all users who don't enter to their account for more than 40 days assuming that i have all needed data on my database
 
what is the best technique to do that batch processing
 
Thanks in Advance
 
 
 


 

Yahoo! Music Unlimited - Access over 1 million songs. Try it free.


Yahoo! Music Unlimited - Access over 1 million songs. Try it free.
YAHOO! GROUPS LINKS



Reply via email to