Re: running a procedure based on a schedule
You've got a couple of options... you can create a script or you can write
and compile a program. The easiest is a script.
Create a .sql file that contains the SQL code to execute the stored
procedure.
example: my_proc.sql
execute procedure my_proc();
Create a script that sets the environment variables needed and then runs
dbaccess.
example: my_script.sh
#!/bin/csh
setenv INFORMIXSERVER ol_myserver
setenv INFORMIXDIR /somewhere/ids_isntalled
setenv PATH $INFORMIXDIR/bin:$PATH dbaccess mydatabase /somewhere/my_proc.sql
and then you create a cron job that executes the script, see man pages for
how to schedule a job via cron.
----- Original Message -----
From: "Gentian Hila" <genti.tech@gmail.com>
To: "Art S. Kagel" <kagel@bloomberg.net>
Cc: <informix-list@iiug.org>
Sent: Thursday, June 15, 2006 1:16 PM
Subject: Re: running a procedure based on a schedule
> How can you cron a stored Procedure ?
>
> On 6/15/06, Art S. Kagel <kagel@bloomberg.net> wrote:
>> Gentian Hila wrote:
>> > Hello,
>> >
>> > Is there any way to schedule a procedure in IDS 9.40 to run at a
>> > certain time and day ?
>>
>> Cron?
>>
>> Art S. Kagel
>>
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>
>