|
A few months back, I mentioned a project I was working on to fill the gaping (and arbitrary) hole that Microsoft implemented in SQL Server Express regarding the complete lack of support for agents. I recently started working on this code again, and I think I finally have the agent tasks worked out (after half a dozen false starts). It supports the following agent tasks:
- A simple timer task that "ticks" at a specified interval
- A file timer task which watches a folder full of files and ticks at a specified interval, allowing the calling to perform processing based on what list each file is in (new, changed, or deleted)
- A FileSystem task that fires an event when the specified file system event occurs
- A WebRequest task that performs the specified web request and fires an event indicating a response is ready.
The idea is that you write an agent module that fires up one of these agent tasks, and merely provide a "DoWork" method that performs the appropriate processing which results in data being added/updated/deleted from the desired database.
The "DoWork" method can be (optionally) handled asynchronously.
One or more of any of the agent tasks can be configured for a given agent module on the fly - just add the necessary configuration info to the module's config file, and the module automatically detects the config file changes and performs the necessary stop, start, or restart processing on the tasks.
Stuff still remaining to be done:
- Implement the modules as auto-loading MEF parts
- Write the Windows service that loads and manages the modules (this can be installed on any machine on your network that can access the database server, or even on the database server itself).
- Write a utility that allows the programmer to manage the configurations and modules without having to do it by manually editing the config files.
There will be an article when it's done.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
|
The Man in the High Castle[^]
Just started to watch this. Beautifully made; the attention to detail is excellent. Quite though-provoking. Can't wait to see the whole series.
|
|
|
|
|
That's next on my list after I finish Constantine.
This space for rent
|
|
|
|
|
Thats Amazon Prime isn't it! any chance of them doing DVD releases of it, I have read the Philip K Dick novel of the same name (loved the bit about Mickey Mouse!  ).
|
|
|
|
|
glennPattonBackInThePUB wrote: I have read the Philip K Dick novel of the same name (loved the bit about Mickey Mouse! ).
I read it many years ago and recall not being that impressed with it though the basic premise was intriguing. However, the program is very good: highly recommend.
glennPattonBackInThePUB wrote: any chance of them doing DVD releases of it,
I'm pretty sure you would be able to download it from somewhere. No idea how you do that but I have heard whispers that it can be done.
|
|
|
|
|
A better WWII alternate book was Robert Harris Fatherland (cold war with the US), also Harry Turtledove did a version that ends up with the German Army V the SS if I remember correctly...can't think of the name.
|
|
|
|
|
Read the first, will look for the second - a prolific author. Quite partial to alternate history fiction.
|
|
|
|
|
If memory serves its called 'In The Presence of Mine Ememies' (just checked amazon it is!) liked the APOD yesterday
|
|
|
|
|
It's on TPB! 
Anything that is unrelated to elephants is irrelephant
Anonymous
-
The problem with quotes on the internet is that you can never tell if they're genuine
Winston Churchill, 1944
-
I'd just like a chance to prove that money can't make me happy.
Me, all the time
|
|
|
|
|
Huh! TPB? The only place I have seen it advertised is on Amazon Prime (UK)  ...
Pirate Bay??? really...
modified 24-Nov-15 8:51am.
|
|
|
|
|
I read the book (and a lot of other Philip K Dick books) many years ago, so I had high hopes for it. Then I showed Herself the trailer and she refused to watch the series "because it has Nazis in".
If the series follows the book (rather better than "Blade Runner" followed "Do android dream of electric sheep?") then I'll work on her, like I had to with "Breaking Bad" - "He's a drug dealer! he sells death! I'm not watching that!" - which she enjoys provided I don't watch it after 9pm as it gets her too wound up to sleep if I do...
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
OriginalGriff wrote: I'll work on her,
That is so funny: had to do the same thing. Eventually persuaded her to watch the first episode and, although it really bothered her, she wants to watch the rest.
BTW, also discovered doctor foster. Seems pretty good.
|
|
|
|
|
OriginalGriff wrote: as it gets her too wound up to sleep if I do
All the better for you I say.
"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
"I don't drink any more... then again, I don't drink any less." - Mike Mullikins uncle
|
|
|
|
|
Jeez--how does she handle the evening news?
|
|
|
|
|
With a lot of shouting and a fair admit of swearwords...
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
The rear view mirror was patented in 1921 and we haven't looked back since...
|
|
|
|
|
I've been told that cigarette lighters in vehicles were discontinued because nobody uses them anymore...
...so why do vehicles still have turn-signals?
-NP
Never underestimate the creativity of the end-user.
|
|
|
|
|
I'm pretty sure BMW's don't, I've never seen one in action on one of those anyway.
|
|
|
|
|
I did a few weeks ago.
Admittedly it was flashing for ages and didn't turn that we at all, but it proves they work.
Bloke probably took it to a garage to complain about an irritating ticking noise whilst he was driving along.
Some men are born mediocre, some men achieve mediocrity, and some men have mediocrity thrust upon them.
|
|
|
|
|
Did you know Yoda was a baker before he became a Jedi? Dough or Dough knot: there is no rye.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
At yeast warn us when the puns are this bad.
|
|
|
|
|
I agree, he kneads to warn us.
"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
"I don't drink any more... then again, I don't drink any less." - Mike Mullikins uncle
|
|
|
|
|
|
I don't think that he'll rise to the occasion.
"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
"I don't drink any more... then again, I don't drink any less." - Mike Mullikins uncle
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
