Click here to Skip to main content
16,021,285 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hi all

Is there any other way to do the same sql scheduler's work using Classic ASP
Posted
Comments
AmitGajjar 16-Aug-12 7:57am    
do you have constraint to use classic ASP ? is it fine if i suggest you with C# dot net and Windows task scheduler ?
[no name] 16-Aug-12 8:00am    
Sry..i have to use Classic ASP but still i want your suggestion
ZurdoDev 16-Aug-12 8:04am    
You can't use ASP. It is server side that only fires when a client requests a page. You need a windows service.

a scheduler is something which will run i the background and will do some action on a given time.

ASP is a server side technology which runs in a web server, there is no guarantee that it will run at a given time or for a extended period, and it is waste of server resources to do so (the web server will probably kill and restart it anyway).

Therefore you need something like a windows service for scheduling.
 
Share this answer
 
Comments
[no name] 16-Aug-12 8:22am    
Is it possible to use windows services in ASP..??
Mehdi Gholam 16-Aug-12 8:27am    
A windows service has nothing to do with ASP they are separate things, it's the same as the sql scheduler. Is it possible to communicate between them? then yes it is.
[no name] 16-Aug-12 8:49am    
can u give me some links or any search stream so that i can search or know more about this..or is there any coding process i can opt for
Mehdi Gholam 16-Aug-12 9:03am    
Just use the sql scheduler if that is what you want.
Wendelius 16-Aug-12 16:47pm    
5+
If you're looking for an alternative for the SQL Server Job Scheduler, for example because it's not included in the Express Edition, have a look at SQL Agent: A Job Scheduler Framework[^].

That's also a good learning material.
 
Share this answer
 
Comments
Mehdi Gholam 16-Aug-12 17:05pm    
5'ed
Wendelius 16-Aug-12 17:09pm    
Thanks :)
[no name] 17-Aug-12 2:22am    
i tried this at my local system but how to add it on server bcoz i have to upload my working file at server system
Wendelius 17-Aug-12 15:44pm    
Don't quite understand the question. Scheduler is just a scheduler so it runs a piece of program whenever you have instructed it to be run. What the program acually does is a different thing. If you have to transfer files etc, you could schedule a batch program or a small .Net executable and so on.
Espen Harlinn 17-Aug-12 5:58am    
5'ed!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900