We have a number of services that are dependant upon the database. The way, I look at it, it links back to the old notion of "active databases" that intelligently run jobs to apply business logic or to notify users of events.
For example, we have a service that polls the "EmailQueue" table and sends any emails left in the "EmailQueue" (conveniently moving them to the "EmailArchive" table). Also, we have services that monitors certain fields for changes in the last 24 hours and notify users of the change via email (or rather via the emailqueue table). If you get the services to run under a specific NT account and setup those accounts in the database it can be a really secure and convenient. That said you will then have to set up a monitoring framework to ensure your services are still running. Also, if you bring your database down (which you shouldn't be doing anyway) you will have to stop your services or risk severe crap-out (crap-out being a technical term). Stephen > -----Original Message----- > From: Stephen Bertram [mailto:[EMAIL PROTECTED] > Sent: Friday, 4 July 2003 8:25 a.m. > To: Multiple recipients of list offtopic > Subject: [DUG-OFFTOPIC]: Use of services > > > Hi All > > We are about to convert a couple of applications into > services so they can run on unattended servers without > requiring a valid logon. > > However one of our developers has expressed concern as the > applications are reliant on SQL Server and he regards any > application that is not self reliant as a poor candidate for > a service. > > I would appreciate comments on limitations or experiences > with services which are reliant on database services. > > TIA > > Stephen > Disclaimer : This communication contains information that is > confidential and the copyright of enSynergy Limited or a > third party. If you are not the intended recipient of this > communication please delete and destroy all copies and > telephone enSynergy Limited on +64 9 9205441 immediately. If > you are the intended recipient of this communication you > should not copy, disclose or distribute this communication > without the authority of enSynergy Limited. Any views > expressed in this Communication are those of the individual > sender, except where the sender specifically states them to > be the views of enSynergy Limited. Except as required by law, > enSynergy Limited does not represent, warrant and/or > guarantee that the integrity of this communication has been > maintained nor that the communication is free of errors, > virus, interception or interference. > > -------------------------------------------------------------- > ------------- > New Zealand Delphi Users group - Offtopic List - > [EMAIL PROTECTED] > Website: http://www.delphi.org.nz > To UnSub, send email to: [EMAIL PROTECTED] > with body of "unsubscribe offtopic" > Web Archive at: http://www.mail-archive.com/offtopic%40delphi.org.nz/ > --------------------------------------------------------------------------- New Zealand Delphi Users group - Offtopic List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of "unsubscribe offtopic" Web Archive at: http://www.mail-archive.com/offtopic%40delphi.org.nz/
