Scheduling Informix SP on NT Solution !!!

> 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 > Vinitha, First of all, you should examine how the demonstration database was created using the "dbaccessdemo.bat" batch file. Before your batch file, you should first set the proper Environment variables. See the "setenv.cmd" file located in your INFORMIXDIX. the command looks like : \\WINNT\\SYSTEM32\\cmd /k E:\\informix\\setenv.cmd && dbaccess - "mysq.sql" try purchasing the NT4 Resource Kit, it has a GUI for the AT command