How best to run periodic code on ver 2.0?

[Bill]

I need to run a web server function every 5 minutes and am running SQL
server too.

What is the best approch to do this ?

call the code from a SQL job
Build a Windows service?
Something else?

or can a .net server run code by itself without anyone logged in

Suggestions please


Thanks

Bill

 

[Cor Ligthert [MVP]]

Bill,

A webservice is forever active, it is called but it is not processing
something on its one, it needs to serve.
Can you tell something more what you want to achieve,

Cor

 

[Bill]

Hopefully this will help explain a little more...

A web client user logs on to my web server and adds a record to a table in
the SQL database. Each record is tagged with an expire time.

I want to check that table once per minute and if an expired record is
found, run some VB code that includes but is not limited to deleting the
record.

A SQL job can run every minute to find expired records, delete them and
start some external procedure. A web client may not be connected when this
happens

I am not sure if anything in my .Net server can be called from SQL though.

Or I could have a standalone program that connects to the database every
minute and does the same thing.

It would be great if my server could do this independent of any client
interation

Just looking for the easiest approch

Thanks

Bill

 

[Guest]

Bill,

While I don't know if this the "optimal" approach, how about writing a
script to do you database work, and running the script from Windows
Scheduler?

Just a thought,

Kim