|
Kevin Marois wrote: I'm actually about now halfway through creating a scheduler app
Yuck. A scheduler can easily get out of hand quickly. For example, you can support very simple schedules: weekdays, weekends; or very complex ones allowing the user to pick every other Wednesday during May, then every Thursday during June, etc. It can get complex quite quickly depending on how flexible you need it.
Right now, I'm not sure how flexible the scheduling needs to be. Likely it will be on the simpler end of the spectrum.
I just need something that allows us to schedule sql stored procedures, possibly command line exes, and who knows what else but is flexible enough we don't have to recompile code every time we need something new scheduled.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
RyanDev wrote: every other Wednesday during May, then every Thursday during June
I once had a similar requirement from some PM, I got sick of him defining ever more detailed needs that he had thought up and simply shoved up a calendar and told him to pick the days and times he wanted it to run.
At some point it goes beyond "scheduling" and becomes random events!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
For SQL Server SP's use SQL Maintenance Plans and for command line exe's use the Windows Task Scheduler.
The task scheduler can be set to run without the user being logged in.
|
|
|
|
|
Im using quartz.net and topshelf as a service base, with the 'jobs' defined in a json config & using cron triggers - so if I were going to allow a user to edit the jobs, I'd be looking at something that could edit the json definitions
|
|
|
|
|
I wish I could help.
I wrote something that languished unupdated a long time before quartz.net was written. (here)[^]
Unfortunately, I never got around to writing a UI component for the project, but that was always meant to be the next step. There really should be a solid solution for that somewhere.
|
|
|
|
|
Thanks. 
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
How about this one, by Mr Simmons
Click[^]
|
|
|
|
|
I used RadScheduleView from Telerik for the UI and for the scheduling engine. The requirement was to look and act like Outlook Calendar and it does.
The UI maintains a set of tables with in SQL Server with all the schedule info. I customized/extended the ScheduleView to hold info about the task I wanted scheduled. A task is just an exe that will run.
I created a Windows Service with Topshelf which makes it really simple to create and debug (your service is just a console app you write).
The DBA did not want the service to poll the database for schedule changes too often, so the UI raises an "event" thru MSMQ to notify when the schedule is changed. The service listens to the queue, hitting the database one time in the morning for today's schedule and any time a schedule change is queued.
It is not as complex as it may sound really. Total dev time was about a week.
I hope I die in my sleep like my grandpa Bart, not screaming and kicking like the passengers of his cab.
|
|
|
|
|
Thanks for the info.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
We use VisualCron. It has all the features you can wish for, regarding scheduling tasks.
|
|
|
|
|
appliedalgo.com - scheduler with grid load balancing support jobs can be built in java/c++/VBA/dotnet... run on Windows/Linux...etc
dev
|
|
|
|
|
Unfortunately I can only reply to questions of this nature on the 3rd Tuesday of months in which the full moon occurs before the 10th.
|
|
|
|
|
Using console app + built in Windows Scheduler. Does the job.
|
|
|
|
|
I used to think that I wanted a job scheduler to do things, but I thought all the .NET ones were over-complicated. So, I spent a couple hours or so and wrote one in to my app. Just have a timer that checks your configured jobs every interval (maybe a minute or less) if it's time to run one, then run it. There's a few other complexities to deal with, but it's not as hard as you think. Think about the configuration for Unix chron as the simplest way do it with lots of timing options.
|
|
|
|
|
Timv256 wrote: but it's not as hard as you think.
The complexity comes in play when you allow users the freedom to schedule their own jobs. For example, do you support the option for just every weekday or do you let them choose which days of the week. Do you allow start and stop time to be different on each of those days, etc. It can get out of hand very quickly depending on how flexible you want it.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
Even with lots of timing options, it wasn't that hard. I had a schedule record and just went through each schedule and executed jobs associated with the schedule during an interval when a schedule was triggered.
Name StartTime EndTime RepeatIntervalMinutes DaysOfWeek DaysOfMonth Hours Minutes NextRunTime LastRunTime
friday7 2014-09-05 00:00:00 2020-04-18 00:00:00 90 Friday NULL 7 NULL NULL 2015-03-13 07:00:49.9115390 -05:00
|
|
|
|
|
Thanks for the input.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
If a great orator is a master debater and an exceptionally good cook a master chef what would a great fisherman be?
New version: WinHeist Version 2.1.0
My goal in life is to have a psychiatric disorder named after me.
I'm currently unsupervised, I know it freaks me out too but the possibilities are endless.
|
|
|
|
|
I can tell you are no cunning linguist.
|
|
|
|
|
A Master Angler[^] of course.
"the debugger doesn't tell me anything because this code compiles just fine" - random QA comment
"Facebook is where you tell lies to your friends. Twitter is where you tell the truth to strangers." - chriselst
|
|
|
|
|
Mike Hankey wrote: what would a great fisherman be?
A figment of your imagination. 
|
|
|
|
|
Quote: A figment of your their imagination
FTFY
Life is like a s**t sandwich; the more bread you have, the less s**t you eat.
|
|
|
|
|
A pathological liar? 
If you have an important point to make, don't try to be subtle or clever. Use a pile driver. Hit the point once. Then come back and hit it again. Then hit it a third time - a tremendous whack.
--Winston Churchill
|
|
|
|
|
Jesus!
PS. Didn't he feed a multitude with just a couple of loaves and a fish? 
|
|
|
|
|
Vivic wrote: Didn't he feed a multitude with just a couple of loaves and a fish?
No, he didn't
PooperPig - Coming Soon
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
