Click here to Skip to main content
15,904,494 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.

 
GeneralRe: Facebook Works Pin
908236523-Nov-15 10:38
908236523-Nov-15 10:38 
GeneralRe: Facebook Works Pin
ZurdoDev23-Nov-15 11:00
professionalZurdoDev23-Nov-15 11:00 
GeneralRe: Facebook Works Pin
Eddy Vluggen23-Nov-15 11:48
professionalEddy Vluggen23-Nov-15 11:48 
GeneralRe: Facebook Works Pin
Sander Rossel23-Nov-15 11:55
professionalSander Rossel23-Nov-15 11:55 
GeneralRe: Facebook Works Pin
Amarnath S23-Nov-15 17:20
professionalAmarnath S23-Nov-15 17:20 
GeneralRe: Facebook Works Pin
Brittle161823-Nov-15 17:38
Brittle161823-Nov-15 17:38 
GeneralRe: Facebook Works Pin
Colin Mullikin24-Nov-15 2:02
professionalColin Mullikin24-Nov-15 2:02 
GeneralSql Server Express Agents Pin
#realJSOP23-Nov-15 9:06
professional#realJSOP23-Nov-15 9:06 
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

GeneralRe: Sql Server Express Agents Pin
Slacker00723-Nov-15 10:34
professionalSlacker00723-Nov-15 10:34 
GeneralThe Man in the High Castle - no spoiler. Pin
R. Giskard Reventlov23-Nov-15 6:39
R. Giskard Reventlov23-Nov-15 6:39 
GeneralRe: The Man in the High Castle - no spoiler. Pin
Pete O'Hanlon23-Nov-15 7:26
mvePete O'Hanlon23-Nov-15 7:26 
GeneralRe: The Man in the High Castle - no spoiler. Pin
glennPattonWork323-Nov-15 7:35
professionalglennPattonWork323-Nov-15 7:35 
GeneralRe: The Man in the High Castle - no spoiler. Pin
R. Giskard Reventlov23-Nov-15 7:46
R. Giskard Reventlov23-Nov-15 7:46 
GeneralRe: The Man in the High Castle - no spoiler. Pin
glennPattonWork323-Nov-15 11:14
professionalglennPattonWork323-Nov-15 11:14 
GeneralRe: The Man in the High Castle - no spoiler. Pin
R. Giskard Reventlov23-Nov-15 11:19
R. Giskard Reventlov23-Nov-15 11:19 
GeneralRe: The Man in the High Castle - no spoiler. Pin
glennPattonWork324-Nov-15 2:55
professionalglennPattonWork324-Nov-15 2:55 
GeneralRe: The Man in the High Castle - no spoiler. Pin
Johnny J.23-Nov-15 18:44
professionalJohnny J.23-Nov-15 18:44 
GeneralRe: The Man in the High Castle - no spoiler. Pin
glennPattonWork324-Nov-15 1:16
professionalglennPattonWork324-Nov-15 1:16 
GeneralRe: The Man in the High Castle - no spoiler. Pin
OriginalGriff23-Nov-15 8:06
mveOriginalGriff23-Nov-15 8:06 
GeneralRe: The Man in the High Castle - no spoiler. Pin
R. Giskard Reventlov23-Nov-15 9:10
R. Giskard Reventlov23-Nov-15 9:10 
GeneralRe: The Man in the High Castle - no spoiler. Pin
jeron123-Nov-15 9:47
jeron123-Nov-15 9:47 
GeneralRe: The Man in the High Castle - no spoiler. Pin
dandy7223-Nov-15 10:15
dandy7223-Nov-15 10:15 
GeneralRe: The Man in the High Castle - no spoiler. Pin
OriginalGriff23-Nov-15 10:42
mveOriginalGriff23-Nov-15 10:42 
JokeObservation Pin
Duncan Edwards Jones23-Nov-15 5:26
professionalDuncan Edwards Jones23-Nov-15 5:26 
GeneralAnother Observation PinPopular
NickPace23-Nov-15 5:33
NickPace23-Nov-15 5:33 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.