in your script, you have to write quote in the connection string (i.e C>
sqlplus 'system/[Email Address Removed] .....'


Another solution is

set ORACLE_SID=yourSID
sqlplus /nolog @D:\oracle\admin\yourSID\scripts\yoursql.sql
exit

and you connect in your sql with
connect system/manager



Degand Xavier

DX sprl

Belgium
----- Original Message -----
From: "Pierre Lemieux "
<oracledba-ezmlmshield-x77327105.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Thursday, June 29, 2006 3:49 PM
Subject: Shutdown script via Job scheduler prompt for password


> Hello LazyDBA's
>
> I am running an Oracle DB 8.1.6 on Windows NT4, and need to shutdown
> periodically for cold backups, the shutdown script is running fine IF
> I run it manually. If I run it via the WinAT scheduler, it prompts
> for a password ??? Any help / suggestions would be appreciated.
>
> Thank you!
>
> Pierre Lemieux
> Columbus, Georgia
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
>


Oracle LazyDBA home page