Make sure the AT job runs as the same userid (windows account or localsystem) as the oracle service. Then it should be OK. Another option would be to have the AT job stop the service itself with a net stop command.

- Andrew

-----Original Message-----
From: Pierre Lemieux [mailto:oracledba-ezmlmshield-x77327105.[Email address protected]
Sent: Thursday, June 29, 2006 6:49 AM
To: LazyDBA Discussion
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