Scheduler--Please Help.

[Sujit Mandal]

Hello

I have an application in ASP.NET.I want a database operation will fire every 24 hr.My project is ASP.Net 2.0(c#) and sql server 2005.
Please suggest me what should i do?
if any reference link or code available than it will be better for me.
Thanks in advance.

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

 

[Bob Speaking]

Hello

I have an application in ASP.NET.I want a database operation will fire
every 24 hr.My project is ASP.Net 2.0(c#) and sql server 2005.
Please suggest me what should i do?
if any reference link or code available than it will be better for me.
Thanks in advance.

Hi Sujit,
there is no acceptable way to invoke time scheduled events from asp.net
application.
There are other ways and I think the most important are :

1) create scheduled sql server job: they run directly on database and they
can execute DTS or SSIS (in 2005), stored proc, queries, etc.
(I don't know how to configure SSIS on sql 2005 )

Regarding jobs there is graphic wizard from enterprise manager (management
studio in your case) to configure a job.
Take a look at http://msdn2.microsoft.com/en-us/library/ms187880.aspx

2) create a service and install it on the webserver.
If you don't have particolar needs I don't suggest you this way. To invoke
time events you need to implements a time scheduler and manage a tasklists
with date/time to configure you jobs. It's a harder way.

If you need only database operations a Sql server job seems to be the
best/easy way

Bob