Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: running sqlplus scripts under AT on NT(oracle 8)

Re: running sqlplus scripts under AT on NT(oracle 8)

From: Joop <JoopvandeWege_at_mail.mococo.nl>
Date: Thu, 21 Jan 1999 09:22:24 +0100
Message-ID: <36A6E3C0.B9A7C68@mail.mococo.nl>

David Spaisman wrote:
>
> Hello:
>
> I have trying to run a batch(also tried as a cmd) file with sqlplus
> scripts run by the start command. Please note that there is a bat file
> attached.
> This is only 1 of 21 similar such sqlplus scripts called within the
> batch file.
>
> When I run the bat file on the command line, either directly on the
> server
> or using rcmd (nt resource kit) from my client machine, the batch files
>
> run. I get the output I am looking for--buffcache.lst as per below..
> When
> I schedule it under AT, I get nothing but the empty lst file used as a
>
> pipe. I have tried running it as a bat file, and a cmd file using
> start. I
> have also used call in a bat file and as a cmd file under AT and I d
Create a special NT user account for running batch files and let the schedule service use this account. The 'SYSTEM' account doesn't have to much priviledges :( for security reasons.

Joop Received on Thu Jan 21 1999 - 02:22:24 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US