daily procedure calls...

Posted in 2000

↪ replying to Benjamin Partlow

Nick Kataria — Mon, 12 Jun 2000 12:05:35 -0700 — source: Informix-list mailing list archive (1991-1998)

To do this you need two things: 1. A shell script which sets your instance's environment and call dbaccess (or isql) and execute procedure your_proc(your_vars). 2. An entry in your crontab to run the script at the time you specify. Regards, Nick. Benjamin Partlow <benpartlow@yahoo.com> wrote in message news:8i3b5r$gq8$1@news.xmission.com... > > How would I call a stored procedure at specified times > every day? i would like to call it just once a day at > 1:00 AM > > Thanks! > > Ben > Learning Informix... > > __________________________________________________ > Do You Yahoo!? > Yahoo! Photos -- now, 100 FREE prints! > http://photos.yahoo.com

Benjamin Partlow — Mon, 12 Jun 2000 12:13:51 -0700 (PDT) — source: Informix-list mailing list archive (1991-1998)

How would I call a stored procedure at specified times every day? i would like to call it just once a day at 1:00 AM Thanks! Ben Learning Informix... __________________________________________________ Do You Yahoo!? Yahoo! Photos -- now, 100 FREE prints! http://photos.yahoo.com

↪ replying to Benjamin Partlow

Carlson@WHSmith — Mon, 12 Jun 2000 15:27:57 -0400 — source: Informix-list mailing list archive (1991-1998)

Benjamin Partlow wrote: > > How would I call a stored procedure at specified times > every day? i would like to call it just once a day at > 1:00 AM > If you're on a UNIX platform then I'd recommend a cron script. If you're on NT, well . . . > Thanks! > No prob. If you need some more detail then give us a ring . . . > Ben > Learning Informix... > Great. Hope all goes well. I think you'll like it. -- John Carlson Informix DBA WHSmith USA #include std_disclaimer.h /* These are my opinions, not my company's opinion */

↪ replying to Benjamin Partlow

Art S. Kagel — Tue, 13 Jun 2000 16:11:11 -0400 — source: Informix-list mailing list archive (1991-1998)

This one is popping up about once a month now. Time for a FAQ entry? Art S. Kagel Benjamin Partlow wrote: > > How would I call a stored procedure at specified times > every day? i would like to call it just once a day at > 1:00 AM > > Thanks! > > Ben > Learning Informix... > > __________________________________________________ > Do You Yahoo!? > Yahoo! Photos -- now, 100 FREE prints! > http://photos.yahoo.com

↪ replying to Art S. Kagel

David Williams — Tue, 13 Jun 2000 23:29:03 +0100 — source: Informix-list mailing list archive (1991-1998)

In article <3946955F.321F58D1@bloomberg.net>, Art S. Kagel <kagel@bloomberg.net> writes >This one is popping up about once a month now. Time for a FAQ entry? > >Art S. Kagel > Saved onto the todo list for the FAQ. >Benjamin Partlow wrote: >> >> How would I call a stored procedure at specified times >> every day? i would like to call it just once a day at >> 1:00 AM >> >> Thanks! >> >> Ben >> Learning Informix... >> >> __________________________________________________ >> Do You Yahoo!? >> Yahoo! Photos -- now, 100 FREE prints! >> http://photos.yahoo.com -- David Williams