|
Thanks!
|
|
|
|
|
I'm looking into using Quartz.net[^] but I haven't seen a good UI so that the user can schedule their own jobs.
Just curious what other people have used. Have you exposed scheduling to end users? If so how detailed was it, meaning could the user choose which days of the week, or perhaps every 3rd Tuesday, etc.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
You can give a try with this one and extend the same based on your requirement.
https://quartznetwebconsole.codeplex.com/[^]
Quote: Have you exposed scheduling to end users? If so how detailed was it, meaning could the user choose which days of the week, or perhaps every 3rd Tuesday, etc. I believe it depends on the target user how well they understand the system. To some extent you can give this ability but as the best practices of Quartz says, you need to be really careful in exposing the scheduling ability as it requires a tight security else any malicious user can even destroy the system.
Thanks,
Ranjan.D
|
|
|
|
|
Personally, I've always used plain .NET Console applications that are being started via the Windows Task Planner (or how it is called now) on e.g. a Web server.
Always satisfied my needs.
|
|
|
|
|
Uwe Keim wrote: I've always used plain .NET Console applications Wouldn't you need someone to be logged on for that to happen? Wouldn't a windows service work better?
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
I configure the task to run when the system starts. I also configure a user to run under.
Windows services are way harder to debug. I never had the need to use it when a console app also did the job.
|
|
|
|
|
OK. Thank you for the input.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
|
A long time ago I this this in Visual FoxPro. Essentially the user got to pick a job, which mapped to a DLL that was run via a scheduler. Mostly for running processes after hours, such as data aggregation.
Now, I'm actually about now halfway through creating a scheduler app in C# 4.5/WPF. It looks like Quartz has many of the same features:
1. Allows the developer to create Groups which contains any number of Tasks. These are essentially assemblies that implement an interface with an "void Execute(object params, object data)" method. The developer codes the assembly and uses the "Publish" feature to put it on the server. Processes and task have an "Order" so you can control the sequence they run.
2. Has the same scheduling options as Windows Scheduler (Minutes, Hours, Days, Months, and Once Only)
2. WPF UI.
3. SQL Server 2008 accessed via WCF hosted in a windows service for single instance or in IIS for multiple server based scheduler instances for load balancing.
4. Allows passing of data returned from one process to another.
5. Full logging.
6. Email Notifications.
I'd like to hear more about what you're looking for as far as requirements.
I'll publish it here when I'm done.
If it's not broken, fix it until it is
|
|
|
|
|
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
|
|
|
|