why not schedule through dbms_jobs, the logic would be encapsulated in the database and would be portable, ie.. if you moved the db to a new machine or a new OS you would not have to worry about an extra .bat and .sql file or having to rewrite the .bat file if you ever moved to unix.
I have sample code if you want to me to post for scheduling analyze in dbms_jobs
steve




Reply With Quote