Timer Question

[Richard Steele (Basemap)]

Hi
In ASP.net (c#) I want to be able to send a request to a user i.e. flag a
status (lets say for example you have a
job allocated to you) and then if they have not acknowledged the job within
a set period of time i.e. 1 hour
that job is then reallocated to someone else. I guess i would add a row to
my DB table with a time stamp and then
1 hour later reallocate the job

I am using MySQL so timed triggers may not be a possibility, would this be
done as a windows service
where every n secs i scan the table comparing the time with the server time
and search for records with
the time equal to +1 hour?

Any suggestions would be gratefully appreciated

--
Thanks
Richard

[Daniel Fisher\(lennybacon\)]

You can use another thread

public class IndexerSchedule
{
public static void Install(int interval)
{
ThreadStart myThreadDelegate = new
ThreadStart(IndexerSchedule.run);
Thread myThread = new Thread(myThreadDelegate);
myThread.Name = interval.ToString();
myThread.Start();
}

private static void run()
{
int interval = 0;
interval =
System.Convert.ToInt32(Thread.CurrentThread.Name);
if (interval>0)
{
while(true)
{
//Do what you want

// Pause Thread
Thread.Sleep(interval*1000);
}
}
}
}

--
Daniel Fisher(lennybacon)
http://www.lennybacon.com
"Richard Steele (Basemap)" <Ri******************@discussions.microsoft.com>
wrote in message news:4C**********************************@microsof t.com...

Hi
In ASP.net (c#) I want to be able to send a request to a user i.e. flag a
status (lets say for example you have a
job allocated to you) and then if they have not acknowledged the job
within
a set period of time i.e. 1 hour
that job is then reallocated to someone else. I guess i would add a row
to
my DB table with a time stamp and then
1 hour later reallocate the job

I am using MySQL so timed triggers may not be a possibility, would this be
done as a windows service
where every n secs i scan the table comparing the time with the server
time
and search for records with
the time equal to +1 hour?

Any suggestions would be gratefully appreciated

--
Thanks
Richard

[Scott Allen]

Hi Richard:

I'd go with either a Windows Service, or even easier is to set up a
scheduled task in Windows. You can write a console mode application
that runs every x minutes and queries the database for jobs to
maintain.

--
Scott
http://www.OdeToCode.com/blogs/scott/

On Thu, 1 Dec 2005 02:59:02 -0800, Richard Steele (Basemap)
<Ri******************@discussions.microsoft.com> wrote:

Hi
In ASP.net (c#) I want to be able to send a request to a user i.e. flag a
status (lets say for example you have a
job allocated to you) and then if they have not acknowledged the job within
a set period of time i.e. 1 hour
that job is then reallocated to someone else. I guess i would add a row to
my DB table with a time stamp and then
1 hour later reallocate the job

I am using MySQL so timed triggers may not be a possibility, would this be
done as a windows service
where every n secs i scan the table comparing the time with the server time
and search for records with
the time equal to +1 hour?

Any suggestions would be gratefully appreciated

[Scott Allen]

It's not scalable if you are creating a thread per user - threads are
precious.

--
Scott
http://www.OdeToCode.com/blogs/scott/

On Thu, 1 Dec 2005 12:18:26 +0100, "Daniel Fisher\(lennybacon\)"
<in**@lennybacon.com> wrote:

You can use another thread

public class IndexerSchedule
{
public static void Install(int interval)
{
ThreadStart myThreadDelegate = new
ThreadStart(IndexerSchedule.run);
Thread myThread = new Thread(myThreadDelegate);
myThread.Name = interval.ToString();
myThread.Start();
}

private static void run()
{
int interval = 0;
interval =
System.Convert.ToInt32(Thread.CurrentThread.Name) ;
if (interval>0)
{
while(true)
{
//Do what you want

// Pause Thread
Thread.Sleep(interval*1000);
}
}
}
}

[Richard Steele]

Thanks Scott, i'll write some test code and see how it goes
--
Thanks
Richard
"Scott Allen" wrote:

Hi Richard:

I'd go with either a Windows Service, or even easier is to set up a
scheduled task in Windows. You can write a console mode application
that runs every x minutes and queries the database for jobs to
maintain.

--
Scott
http://www.OdeToCode.com/blogs/scott/

On Thu, 1 Dec 2005 02:59:02 -0800, Richard Steele (Basemap)
<Ri******************@discussions.microsoft.com> wrote:

Hi
In ASP.net (c#) I want to be able to send a request to a user i.e. flag a
status (lets say for example you have a
job allocated to you) and then if they have not acknowledged the job within
a set period of time i.e. 1 hour
that job is then reallocated to someone else. I guess i would add a row to
my DB table with a time stamp and then
1 hour later reallocate the job

I am using MySQL so timed triggers may not be a possibility, would this be
done as a windows service
where every n secs i scan the table comparing the time with the server time
and search for records with
the time equal to +1 hour?

Any suggestions would be gratefully appreciated