RE: scheduling Informix stored procedures on NT
Posted in 1997
Vinitha
How about:
dbaccess dbname <<!
EXECUTE PROCEDURE spname;!
If you want to use your original form, ie:
dbaccess dbname <spname
your spname file should have "EXECUTE PROCEDURE spname;" (where spname is the name of the SP you created in the database).
HTH
Sujit
----------
From: Vinitha[SMTP:bfldc2@plutonium.bflsl.soft.net]
Sent: Wednesday, August 06, 1997 4:29 PM
To: informix-list@rmy.emory.edu
Subject: scheduling Informix stored procedures on NT
Hello,
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