Hi,
Does anyone know a way to schedule a simple SQL script using P2000 or PV8 to
run automatically at a predetermined time?



Cheers

John

Internally, there's no option to do this at this time. However, you can
schedule a SQL script to execute via a command line. It should be possible to
write a Perl script to do this, if you want to dig into some code.

Our SQLExec utility provides the same functionality as well, from any Win32
command line. It can be quite useful for either executing entire scripts of
statements (such as building new databases during an application installation)
or scheduling scripts or stored procedures. See
http://www2.goldstarsoftware.com/sqlexec.htm for more details. I can also get
you a trial version, if you want to see if it'll work for you.
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Pervasive.SQL Service & Support Classes ***
Chicago: March, 2004: See our web site for details!


John Anisy wrote: