John W. Colby
jwcolby at colbyconsulting.com
Tue Aug 23 15:56:03 CDT 2005
LOL, this is an MDB. John W. Colby www.ColbyConsulting.com Contribute your unused CPU cycles to a good cause: http://folding.stanford.edu/ -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller Sent: Tuesday, August 23, 2005 4:49 PM To: dba-vb at databaseadvisors.com Subject: RE: [dba-VB] VB.Net - Hook an open program I think that you are going about this is in a seriously wrong way, JWC. IMO, you create the jobs and schedule them and keep the FE _way_ out of the picture. Unless I am misunderstanding you, you are putting the FE before the BE -- which IMO is the biggest no-no in the SQL business. To put it another way, everything you can blame on MS should be blamed on MS. Set it up in the BE and DO NOT INTERFERE. Not to say there are no reasons for services, but from what you have described thus far, this is NOT one of them. Schedule the job at a frequency you like, then leave your FEs do realize the results. You muddy the waters too much by asking the FEs to muddy the waters. You are the worm chasing its tail, IMO, in the direction you are going. AF`s Rule 1: everything the BE can do, the BE should do. Corollary: no code affecting scheduled sprocs, udfs, etc. should exist in the FE. -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of John W. Colby Sent: August 22, 2005 11:06 PM To: dba-vb at databaseadvisors.com Subject: [dba-VB] VB.Net - Hook an open program I want to load an application that loads scheduled tasks into classes from a database. Once the tasks are loaded I want my service to call this application and ask it to run any tasks that the scheduler deems ready to run. Is it possible for one program to call another open (running) program? I would like the scheduler to be part of the service but until the system is debugged I want the scheduler to be a program with a user interface that I can watch. For this reason, the service would cause the scheduler to load, and then periodically "call" the scheduler and ask it to check its list of tasks and run any as appropriate. Is this possible? John W. Colby www.ColbyConsulting.com Contribute your unused CPU cycles to a good cause: http://folding.stanford.edu/ _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com