Re: scheduling Informix stored procedures on NT

NT has an `AT` command and /usr/bin/ksh??? I'm a little confused here . . . please clarify . . . Jacob Salomon wrote: > Vinitha wrote: > > > 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 ? > > While you can't runa stored procedure by using a naked AT command, you > > can write a shell script to invoke dbaccess and run a procedure. > > But first, I note that your dbaccess command is the form that expects > to > use the screen editor and menus. Try this from the shell prompt: > > dbaccess yourdatabase - > > dbaccess will give you the message: > > Database selected. > > and start prompting you with: > > > > > You can type in SQL commands directly. Terminate a command with a > semicolon (;). Of course you can't edit and correct erroneous SQL > commands; you would have to type them over. > > Now, that shell script you run with the AT command: It would look like > > this the following: > > #!/usr/bin/ksh > # Shell script to be executed by the AT command. > # > dbaccess mydatabase - <<%% > execute procedure yadayada(param1, param2);> %% > > If you don't know what that <<%% business it, go read up on how to use > > the shell. (Also the newsgroup comp.unix.shell) > -- > -- Jake (In pursuit of undomesticated aquatic avians) > > +----------------------------------------------------------+ > |Aside from that, how did you enjoy the play, Mrs. Lincoln?| > +----------------------------------------------------------+ -- * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ADDRESS ALTERED TO FOIL SPAMMERS: Remove "*NO-SPAM*" to reply. Cosmo Lee Multi-User Computer Systems Brooklyn, NY "JUST SAY 'NO' TO SPAM" * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *