Home » RDBMS Server » Networking and Gateways » SQLPlus and Command File
- SQLPlus and Command File [message #66078] Tue, 06 November 2001 06:00 Go to next message
craigoc
Messages: 1
Registered: November 2001
Junior Member
Hi, hope someone can help me out with this one. I have a cmd file (Win2K) that executes on a scheduled basis. In this file, I call sqlplus and try to connect to a db which opens up another window. What happens sometimes is I can't get a connection (tns-12203) and the second window remains open. When this happens the cmd file is locked.

What I would like to know is if it's possible to somehow make the second window close when it can't connect, so the scheduled job can run again. I do have a "whenever sqlerror exit failure" statement in the sql. Thanks very much!

----------------------------------------------------------------------

Report message to a moderator

- Re: SQLPlus and Command File [message #66079 is a reply to message #66078] Tue, 06 November 2001 06:55 Go to previous message
SUBBARAO MANCHIKANTI
Messages: 8
Registered: December 2000
Junior Member
I hope if you will set the time for scheduled task to stop job if it fails. There is an option in scheduled task window. Check that option.

----------------------------------------------------------------------

Report message to a moderator

Previous Topic: Re: Stored Procedures accessed via Visual Basic
Next Topic: Re: ORA-12222 while connecting from WindowsNT client
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 01 09:43:21 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.