I was wondering if anyone has an answer on how to achieve the following:

I have a tracking system which has times a task was created.
I also have a escalation process I must follow based on time frames

I was wondering if someone could tell me how to schedule a query from 
within my asp.net application which would the produce results of the tasks 
which are over their allotted times.

I would like to automate this page so that it updates itself every 5 
minutes.  Additionally if this page is not open then i still need it to 
update so that i can send emails to the appropriate people.

Any assistance would be greatly appreciated.

I code in vb and any examples would additionally be greatly appreciated.

Thanks


Warren

If your using SQLServer, you can use SQLAgent to run querys at regular
time intervals.  It can be very powerful and may be a more effective way
to accomplish what you describe.  Then you ASP page would be much
simpler and only need to monitor the results of the job.

Steve Brownell, MCP
AllMeds, Inc.

-----Original Message-----
From: Warren Nielsen [mailto:warren.nielsen@a...]
Sent: Wednesday, May 15, 2002 1:11 AM
To: ADO.NET
Subject: [ado_dotnet] Scheduling a Query


I was wondering if anyone has an answer on how to achieve the following:

I have a tracking system which has times a task was created.
I also have a escalation process I must follow based on time frames

I was wondering if someone could tell me how to schedule a query from
within my asp.net application which would the produce results of the
tasks
which are over their allotted times.

I would like to automate this page so that it updates itself every 5
minutes.  Additionally if this page is not open then i still need it to
update so that i can send emails to the appropriate people.

Any assistance would be greatly appreciated.

I code in vb and any examples would additionally be greatly appreciated.

Thanks


Warren

This may not be what you are looking for, but perhaps if you simply set
up your ASP to fire off the query when it loads.  Then you can create a
small program (or use windows scheduler or whatever) to simply open that
ASP page at some given interval.  If your asp page is set up to close it
self down when it is done, then you will never have more than one
instance open at any given time.

----------------------------------------------------------------------

Subject: Scheduling a Query
From: "Warren Nielsen" <warren.nielsen@a...>
Date: Wed, 15 May 2002 05:10:32
X-Message-Number: 1

I was wondering if anyone has an answer on how to achieve the following:

I have a tracking system which has times a task was created.
I also have a escalation process I must follow based on time frames

I was wondering if someone could tell me how to schedule a query from
within my asp.net application which would the produce results of the
tasks
which are over their allotted times.

I would like to automate this page so that it updates itself every 5
minutes.  Additionally if this page is not open then i still need it to
update so that i can send emails to the appropriate people.

Any assistance would be greatly appreciated.

I code in vb and any examples would additionally be greatly appreciated.

Thanks


Warren
----------------------------------------------------------------------