Is there any alternate for SQL job scheduler

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

ASP

SQL-Server

Hi all

Is there any other way to do the same sql scheduler's work using Classic ASP

Posted 16-Aug-12 1:47am

Code-Hunt

Add a Solution

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.

2 solutions

Solution 1

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.

Posted 16-Aug-12 2:03am

Mehdi Gholam

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+

Mehdi Gholam 16-Aug-12 17:05pm

Thanks Mika!

Espen Harlinn 17-Aug-12 5:57am

5'ed!

Mehdi Gholam 17-Aug-12 6:08am

Thanks Espen!

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Wendelius · Accepted Answer · 2012-08-16T10:47:00

Solution 2

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.

Posted 16-Aug-12 10:47am

Wendelius

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!

Wendelius 17-Aug-12 15:42pm

Thanks :)