Schedule SQL*Plus on NT

From: Corey G. <corey_gill_at_my-deja.com>
Date: Tue, 13 Jul 1999 14:44:46 GMT
Message-ID: <7mfjca$keg$1@nnrp1.deja.com>

I would like to schedule some sql*plus scripts on Windows NT. A scheduled cmd file starts sql*plus like this:

sqlplus user/password_at_dbname script.sql scriptparm1

The only problem I have is that if the username/password or db connect string is incorrect, sql*plus will remain on the console prompting for another username. Is there any way to get sql*plus to abort and exit if the first connection attempt fails ? Or are there better ways to handle this ?

Also, is using the sqlnet.ora parameter: sqlnet.authentication_services = (NTS) considered secure ?

BTW, I'm using 8.04, but have tried sqlplus on 805 and 815 and get the same behaviour.

Thanks,
--
Corey Gill
corey_gill_at_hotmail.com

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jul 13 1999 - 09:44:46 CDT