How to execute SP at given frequency?

Posted in 2000

↪ replying to CN

Thomas Parsli — 25 May 2000 15:09:37 +0200 — source: Informix-list mailing list archive (1991-1998)

CN <cnarog@ddc.daewoo.com.pl> writes: > Hi folks, > > We need to start stored procedures at given frequency of time (dayly, > weekly, monthly). Is there any useful function in Informix 7.2 for > time checking? No, but cron is excellent:) (Well; you can look at the time/date, but there's no scheduling a'la cron) Thomas

CN — Thu, 25 May 2000 15:06:06 +0100 — source: Informix-list mailing list archive (1991-1998)

Hi folks, We need to start stored procedures at given frequency of time (dayly, weekly, monthly). Is there any useful function in Informix 7.2 for time checking? Thanx in advance CN

↪ replying to CN

stumbde — Thu, 25 May 2000 15:50:03 -0400 — source: Informix-list mailing list archive (1991-1998)

You can use cron to run the procedue embeded in a KSH file. dbaccess databasename proc.sql Proc.sql contains the execute statement for the procedure. Sameer CN <cnarog@ddc.daewoo.com.pl> wrote in message news:392D334E.1DF68AEF@ddc.daewoo.com.pl... > Hi folks, > > We need to start stored procedures at given frequency of time (dayly, > weekly, monthly). Is there any useful function in Informix 7.2 for > time checking? > > Thanx in advance > > CN > >