473,325 Members | 2,860 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

How best to run periodic code on ver 2.0?

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
Aug 18 '06 #1
3 1110
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" <bi**@aa.comschreef in bericht
news:1p********************************@4ax.com...
>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

Aug 18 '06 #2
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


"Cor Ligthert [MVP]" <no************@planet.nlwrote in message
news:O4**************@TK2MSFTNGP03.phx.gbl...
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" <bi**@aa.comschreef in bericht
news:1p********************************@4ax.com...
>>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


Aug 18 '06 #3
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

--
digipede - Many legs make light work.
Grid computing for the real world.
http://www.digipede.net
http://krgreenlee.blogspot.net
Aug 18 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Hans Forbrich | last post by:
The following is a Request for Discussion, following up on some recent posts about distributing a periodic news group 'Charter and FAQ' post. While not formally following RFC/RFD rules, the intent...
0
by: Hans Forbrich | last post by:
Section 1. Ballot: ------------------- 1.YES NO: I agree that there should be a periodic post describing the newsgroup charter and providing a FAQ on newsgroup usage. 2.MONTHLY BI-WEEKLY...
0
by: Hans Forbrich | last post by:
Section 1. Ballot: ------------------- 1.YES NO: I agree that there should be a periodic post describing the newsgroup charter and providing a FAQ on newsgroup usage. 2.MONTHLY BI-WEEKLY...
1
by: MickeyBob | last post by:
I want to develop a web application that displays real- time data. I'm thinking that a typical web form would have between 25 to 75 values that needed to be updated every second or so. The...
2
by: Greg | last post by:
Hi All- I have searched around a bit and haven't found anything that addresses my exact question... I have a db that is moderately busy (a couple million records added over a day, 60-300 db...
5
by: nishantxl | last post by:
Hi there, I am looking to design a project using C++ The main objective of the project is to display details of periodic table elements such as periodic element name, properties(such as atomic...
3
by: sophie_newbie | last post by:
Hi, I'm running a python cgi script on a frontend web server and I want it to spawn another script (that takes a long time to run) on a backend number crunching server thats connected to the...
5
oranoos3000
by: oranoos3000 | last post by:
hi I want to repeat executing a seri of the code in page in interval periodic time without use from infinite loop and i prefer that page is not refreshed only a seri of the code is execute....
3
oranoos3000
by: oranoos3000 | last post by:
hi i want to get time of server with ajax,php,javascript i use under scritp and with method onload i get time on server and show on the page so i want in a period time the same function is run...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.