Re: running a procedure based on a schedule

Thanks a lot everybody. This was very helpful. As very new to Informix I had no idea what DB-Access is. Now I think it will open a lot of other possibilities for me to manipulate the db. Thanks again. On 6/15/06, Adam Tauno Williams <adam@morrison-ind.com> wrote: > On Thu, 2006-06-15 at 14:16 -0400, Gentian Hila wrote: > > How can you cron a stored Procedure ? > > dbaccess {DATABASE} <<EOT! > EXECUTE PROCEDURE {procedure_name}; > EOT! > > - or - > > echo "EXECUTE PROCEDURE {PROCEDURENAME};" | dbaccess {DATABASE} > > > See "Using DB-Access Interactively in Non-Menu Mode" (page 43) at > http://publib.boulder.ibm.com/infocenter/idshelp/v10/topic/com.ibm.pdfs.doc/25122770.pdf > > > > > Is there any way to schedule a procedure in IDS 9.40 to run at a > > > > certain time and day ? > > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >