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

Aug 18 '06 #1

Subscribe Reply

1120

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" <bi**@aa.comsch reef in bericht
news:1p******** *************** *********@4ax.c om...

>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

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

"Cor Ligthert [MVP]" <no************ @planet.nlwrote in message
news:O4******** ******@TK2MSFTN GP03.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.comsch reef in bericht
news:1p******** *************** *********@4ax.c om...
>>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

Kim Greenlee

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

Similar topics

2440

RFD: Periodic FAQ & Charter post

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 is to use the rules as a guide for the discussion and make a more formal Request for Comment and a follow-up formal vote, possibly before year-end....

Oracle Database

1833

CFV: comp.databases.oracle Periodic FAQ Post

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 WEEKLY: The post should be transmitted with this frequency.

Oracle Database

1808

Final CFV: comp.databases.oracle Periodic FAQ Post

by: Hans Forbrich | last post by:

Oracle Database

1347

Best way to get real-time data via web form

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 original data source would be an OPC (i.e., OLE for Process Control) server (preferred) or a database (e.g., SQL Server). I've surfed all over the web...

.NET Framework

2507

Best way to delete data from operating db?

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 hits per second, average about 120 or so). The database is in constant use and the server can't be stopped under normal circumstances.

MySQL Database

8877

Design of C++ Periodic table project

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 number and atomic mass) for each periodic number entered by user. I am thinking to input all the data regarding each periodic element number in form...

C / C++

2087

Best way to spawn process on back end computer

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 same network. What do you think is the best way to do this? I have a few ideas but I'm sure there is a "best" way to go about this. Thanks.

Python

1536

executing a seri of the code in page in interval periodic time

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. this codes execute repeatedly How can i carry out this work? thanks a lot

Javascript

5326

calling function in a periodic time

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 but result is fixed and error is given my script is <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"...

Javascript

7694

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...

General

7609

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...

Windows Server

7921

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...

C / C++

7666

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...

Windows Server

6278

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...

Career Advice

5217

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...

C# / C Sharp

3651

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...

Networking - Hardware / Configuration

3636

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1208

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP