Re: schedule a program to run base on data in a table

Sounds like you want a trigger. In your case it may be a trigger on insert of new orders. It would probably call a stored procedure that actually decides exactly what to do. The "program" may then be in that stored procedure, another stored procedure or a separate program executed via the "system" command in the stored procedure depending on what you want to do. You do of course have to be carefull about what a trigger does so you do not slow down other execution to unacceptable levels. On Mon, 17 Aug 1998 12:04:41 +0500, abep@bhphotovideo.com (Abraham Perl - Application Developer) wrote: > >how can i schedule a program to run based on data in a table >(e.g. run this program if the count of orders for this customer is 10) Nils Myklebust NM Data AS Norway E-mail: Nils.Myklebust@nmdata.com FAQ at: http://www.iiug.org/techinfo/faq/faq_top.html (Now with ODBC info under "Third party products".)