What are ways to perform scheduling?

Question

1.00/5 (1 vote)

See more:

I have a web application through which client can put jobs in the job queue.

Now I want to write a code which will reside on the server and keep on running all the time and keep on checking whether there is any pending job in the job queue table, if it is there then start a thread for each job and perform that job.

My question to you all experts is that, what are possible ways to do above task?

~Amol

Posted 13-Dec-11 22:35pm

Amol_27101982, India

Add a Solution

2 solutions

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)

E.F. Nijboer · Answer 1 · 2011-12-14T01:01:00

Solution 1

You can create a scheduled task. Have a look here http://publib.boulder.ibm.com/tividd/td/BSM/SC32-9084-00/en_US/HTML/bsmd62.htm[^]

Good luck!

Posted 14-Dec-11 1:01am

E.F. Nijboer

v2

Comments

Amol_27101982, India 14-Dec-11 7:33am

Thanks for your answer, but apart from executing commands I need to perform other tasks which involves some business logic like start/stop threads.

E.F. Nijboer 14-Dec-11 14:27pm

You can create a TaskSchedule:
http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.agent.jobschedule.aspx
I don't know exactly what you mean by starting and stopping threads but it might be something less suitable to implement as a sqlserver job. Why would you want to start and stop the threads yourself? Wouldn't it render the sqlserver scheduler useless?. Because that would normally run the job(s) as scheduled for you.

#realJSOP · Answer 2 · 2011-12-14T01:13:00

Solution 2

Write a Windows service that can get job info from the database, and then run the jobs on the specified schedules. Of course, you didn't describe the nature of the "jobs", so it's impossible to be more specific with suggestions.

Posted 14-Dec-11 1:13am

#realJSOP

Comments

Amol_27101982, India 14-Dec-11 7:35am

Thanks for your answer, I thought of this way but is there any another approach that we can follow?

#realJSOP 14-Dec-11 8:18am

You asked for possible ways to do what you want, and have been provided with two possible ways. And THEN, you down-voted both of the answers. I'm sure there are a couple of other ways youcan accomplish what you want, but the method I described is the way *I* would do it. I'm certainly not the end-all/be-all of programming talent, but I *have* been programming for over 30 years, and based on that experience, I recommended the best course of action as I see it. That's all I have for you.

Amol_27101982, India 14-Dec-11 8:39am

I completely respect your answer John and please don’t misunderstand me …
Only the thing that I am expecting is to know other possible ways…