Re: scheduling Informix stored procedures on NT
Posted in 1997
In reply to Vinitha's email about scheduling Informix stored procedur, on
7 Aug 97
> Hello,
Hi Vinitha,
>
> I am trying to run certain Informix stored procedures at scheduled time
> intervals on NT.
> For scheduling , I put the "dbaccess <dbname> <spname?" command in a
> batch file and try to run it with the "at" command on NT. This is not
> working. In fact even if I try running dbaccess itself, the dbaccess
> screen just flashes on screen and disappears. Any ideas on why this is
> happening, and how to implement my basic requirement ?
>
> Thanks in advance,
> Vinitha
I am not very sure about the Windows NT but on Unix you need to set the
Informix related environmental variables prior to dbaccess itself. The
variables INFORMIXDIR, PATH , TBCONFIG/ONCONFIG as well as
INFORMIXSERVER (ver 7.x) should be set.
HTH,
Ravi...
--
Ravi Joseph Pinto, mailto:ravi@in.dhl.com
Senior Consultant, voice :91-22-8503000
Astra Infotech, Mumbai, India extn. 1531
If Network is computer, how come Sun makes servers, not routers ;-)
PS : Standard disclaimers apply.