RE: scheduling Informix stored procedures on NT
Vinitha
Dont know anything about NT. There was a post here on your thread which =
said that the NT at functions differently than the Unix at. This is how =
I would go about doing it in Unix, so please extrapolate the information =
for NT if at all possible.
echo "dbaccess $DBNAME < spfile" | at midnight today next day
This will run your SP each day at midnight every day starting today. If =
you want other times or other frequencies of running the job then you =
can substitute the appropriate parameters. The first argument for at is =
the time the job needs to be run. The second is the date. The third and =
fourth specify how frequently you want to run the job.
There may be other ways to do this in NT, for instance:
at -f spjob.sh midnight today next day
or=20
at midnight today next day < spjob.sh
where spjob.sh contains:
dbaccess $DBNAME <<!
EXECUTE PROCEDURE spfile;!
HTH
Sujit
----------
From: BAZIC Project Group[SMTP:bfldc2@bfl.soft.net]
Sent: Friday, August 08, 1997 3:49 AM
To: spal@scotch.den.csci.csc.com
Subject: Re: scheduling Informix stored procedures on NT
Sujit,
Thanks for the prompt reply. However, what you suggest would just run =
the sp onetime. What I want to do is automate the running. So I am =
looking at executing it from the NT "at" command, which is not working. =
Any further ideas ?=20
Vinitha
>=20
> Vinitha
>=20
> How about:
>=20
> dbaccess dbname <<!
> EXECUTE PROCEDURE spname;> !
>=20
> If you want to use your original form, ie:
>=20
> dbaccess dbname <spname
>=20
> your spname file should have "EXECUTE PROCEDURE spname;" (where spname =
is the name of the SP you created in the database).
>=20
> HTH
>=20
> Sujit
>=20
> ----------
> 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
>=20
> Hello,
>=20
> 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 ?
>=20
> Thanks in advance,
> Vinitha
>=20
>=20
>=20
>=20
>=20