Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 5 of 5 total
Thread Best approach to holding 'Task Schedule' data
Tue, Nov 5 2013 11:27 PMPermanent Link

Adam H.

Hi,

I'm currently developing a 'Reporting Service' for one of my databases
which I plan to make work similar to the Windows Task Scheduler where a
user can set the schedule / interval on how often each Report should be ran.

What I'm having difficulty deciding is how exactly I should store this
information.

For example, the options that I need to be able to store are such of:

1st Day of every month at 12:00am
1st Wednesday of every month at 12:00am
Every Day at 12:00am
Every Wednesday at 12:00am
Every Tuesday and Thursday at 12:00am

etc, etc, etc...

I have no idea how Windows Task Schedule actually stores this data -
whether there's one field that it parses the information from, or
multiple fields, etc.

I was just wondering if anyone has ever done something similar to this
before and if there's a best practice, or good approach as how to best
handle something like this?

The other work around I guess is just to make the program in a way that
can be 'called' from windows task schedule with a whole lot of
parameters to say which report to run, criteria, etc and just let
windows do all the leg work when it comes to scheduling and have a lot
of entries in Windows, although I do like the idea of having this all
'in house' so to speak.

Cheers

Adam.
Wed, Nov 6 2013 3:54 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Adam


The first thing I often do with stuff like this is to look on Torry - there are 13 shareware / commercial components.

Roy Lambert
Wed, Nov 6 2013 5:19 PMPermanent Link

Adam H.

Hi Roy,

> The first thing I often do with stuff like this is to look on Torry -
there are 13 shareware / commercial components.

A great idea. Why re-invent the wheel ey. Smile

Cheers

Adam.
Fri, Nov 8 2013 4:49 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Adam


This was on the Embarcadero ngs:

http://www.sicomponents.com/taskscheduler.html

Roy Lambert
Sun, Nov 10 2013 4:43 PMPermanent Link

Adam H.

Thanks Roy,

I was actually thinking of not using the Windows Task Scheduler (Having
my own built into the application / service I'm writing), but it looks
like it's just going to be a lot easier to use what's already there in
Windows.

Cheers

Adam.
Image