How to schedule datacentric Tasks at specific datetime?

  • Thread starter Thread starter Manish Jain
  • Start date Start date
M

Manish Jain

Platform : ASP.Net/C#, Sql Server 2000 (Web Project)
-----------------------------------------------------------

I need to schedule some tasks like Alert Generation at say 0:00 hrs
everyday. And there are cases like reminders for meetings at specific time
on specific date.

One option available to me is to write a stored Procedure and schedule its
execution at 0:00 hrs in SQL Server.

But there are lot of Business Rules associated like "do not generate alert
for a manager". And I do not want to pass on the Business Logic to the
Database.

Is there any other option available for me to execute some C# code at
scheduled time?

Thanks and Regards

Manish
www.acidaes.com
 
Hi,

You could install a scheduled job, if you have a business logic layer then
create a console app and use the business layer to execute it.

Cheers,
 
Back
Top