daily procedure calls...
Benjamin Partlow asked how to call a stored procedure daily at 1:00 AM. Nick Kataria said to write a shell script that sets the Informix environment and runs dbaccess or isql with EXECUTE PROCEDURE, then schedule it from crontab. John Carlson also recommended cron on UNIX. Art Kagel noted the question recurred monthly and David Williams added it to the FAQ todo list.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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
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 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 */
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
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