Scheduling task from ASP.NET

Question

0.00/5 (No votes)

See more:

Hi,

I have a big problem. I have a database with data about a bidding site.
I would like to run a checking every 2 or so minutes to see if a bidding has expired or finished by buying, and send messages to the users if the case.
The problem is that i use Microsoft Sql Server 2008 R2 Express, meaning i don't have Server Agent.
This is a project for a competition, so i would like that the scheduling was made from ASP.NET, and not using other web host stuff.

I've found a tricky solution, making use of the cache expire event, but i can't make it work.
http://beckelman.net/post/2008/09/20/Simulate-a-Windows-Service-Using-ASPNET-to-Run-Scheduled-Jobs.aspx

I use Visual Studio 2010, Microsoft SQL Server R2 Express, so if you can please provide compatible solutions.

Thank you for your help

Posted 29-Nov-10 9:02am

Shaman203

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ROGDEV · Accepted Answer · 2010-11-29T14:46:00

A non-ASP.Net way to do this would be to add a console application project to your solution. One way to build it would have a main controller thread, responsible for scheduling/instantiating two worker threads.

One worker is responsible for keeping your database mirrored/synched with the remote service (continuously monitors the database for items which are not expired && not refreshed within the past X minutes).

Another worker is responsible for monitoring your items for changes (expiration, etc) and raising a notification event.

The final worker is responsible for sending the notifications via in-site message, email, sms, etc. You could trigger this worker through events passed through event aggregation service.

Your console application can run on any machine that has access to the database, doesn't have to be the SQL or Web box specifically. Depending on how you build it, you could have the workers "pick up" where they left off, in case the service is turned off for a period of time.

Hope this helps, good luck with the competition.

AspDotNetDev · Accepted Answer · 2010-11-29T10:10:00

Create a page that calls the code behind for the page every 2 minutes. That code behind method would then do any checking against the database that is required. You could perform the call however you like (e.g., force the page to refresh every two minutes, or just use a JavaScript timer and call a Page Method every 2 minutes).

You could then keep that page open constantly... you could probably even have the page open on the server itself (which may be your local computer if you're just debugging). As long as a browser is open and pointing to that page, that page can interact with the database.

You could also create a Windows Service, but depending on your setup, that may or may not be workable for you. Also depends on what you mean by "send messages to the users". If you mean email, then a service would work. If you mean to the webpage they already have open, that can be accomplished using the above technique (page methods or timed postbacks).

Scheduling task from ASP.NET

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0