Hey boys and girs;

OS= Win NT
Oracle= 8.1.6

I am trying to write a simple batch program to run my analyze script once a week. I have the analyze.sql, that was the easy part.

What I want to do is create a batch program that will log into SQL and call the .SQL script I have created.

I have gotten as far as getting the .CMD to log on to the correct instance but how do you get it to call the .sql script once you are in a sql session?

Thanks in advance

MH