RE: Weird Windoze 'AT' Behavior

2002-07-17 Thread Muqthar Ahmed

Dave,

Did you stop and start SCHEDULER.if not do it, it will fix the problem.

Muqthar Ahmed
DBA

-Original Message-
Sent: Wednesday, July 17, 2002 9:43 AM
To: Multiple recipients of list ORACLE-L


I have Oracle 8.1.7 running on NT.  I do cold backups nightly and have a batch file 
that is called by the NT 'AT' scheduler.  I recently changed some lines of commands in 
the batch file and since then when the batch file is executed by 'AT' only the lines 
that I did not edit are executed.
If I execute the batch file from the command prompt it works fine.  I deleted the job 
from 'AT' and then entered it back in but still getting this odd behavior of only 
executing the commands that I did not edit.  Our SA's know nothing about 'AT' so they 
are of no help.
Has anyone else seen this odd behavior in the 'AT' function in Windoze?  I know you 
find it hard to believe that something can be weird in Windoze.  ;o)
And yes, I am soon planning on learning RMAN and do hot backups.  I have the 8i Backup 
and Recovery Handbook for my reading pleasure.  I see the app that is being used going 
to a 24X7 schedule.  Now it is only used during the day.

Thanks,

Dave
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Farnsworth, Dave
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Muqthar Ahmed
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Re: Weird Windoze 'AT' Behavior

2002-07-17 Thread Alan Davey

Dave,

I've found AT to be flakey at best.  I haven't had your specific problem, but I have 
had problems where AT would only occasionally run when it was supposed to.

I don't remember if it was a specific NT patch or a version of IE explorer, but one of 
these will install a Scheduler utility, which I've found to be pretty reliable.  If 
you open My Computer (or explorer) you should see a folder called Scheduled Tasks.  
Double-click and then use the wizard to set up a call to your batch file.

HTH,
-- 

Alan Davey
[EMAIL PROTECTED]
212-604-0200  x106


On 7/17/02, Farnsworth, Dave [EMAIL PROTECTED] wrote:
I have Oracle 8.1.7 running on NT.  I do cold backups nightly and 
have a batch file that is called by the NT 'AT' scheduler.  I recently 
changed some lines of commands in the batch file and since then when 
the batch file is executed by 'AT' only the lines that I did not 
edit are executed.
If I execute the batch file from the command prompt it works fine. 
 I deleted the job from 'AT' and then entered it back in but still 
getting this odd behavior of only executing the commands that I did 
not edit.  Our SA's know nothing about 'AT' so they are of no help.
Has anyone else seen this odd behavior in the 'AT' function in Windoze? 
 I know you find it hard to believe that something can be weird in 
Windoze.  ;o)
And yes, I am soon planning on learning RMAN and do hot backups. 
 I have the 8i Backup and Recovery Handbook for my reading pleasure. 
 I see the app that is being used going to a 24X7 schedule.  Now 
it is only used during the day.

Thanks,

Dave
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Farnsworth, Dave
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing 
Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and 
in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Alan Davey
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: Weird Windoze 'AT' Behavior

2002-07-17 Thread Adrian Roe

Have you fully qualified the path to the batch file ? Maybe the previous
batch file been copied into another directory in the PATH and AT is finding
this one before it finds your edited file.

Ade

-Original Message-
Sent: 17 July 2002 14:43
To: Multiple recipients of list ORACLE-L


I have Oracle 8.1.7 running on NT.  I do cold backups nightly and have a
batch file that is called by the NT 'AT' scheduler.  I recently changed some
lines of commands in the batch file and since then when the batch file is
executed by 'AT' only the lines that I did not edit are executed.
If I execute the batch file from the command prompt it works fine.  I
deleted the job from 'AT' and then entered it back in but still getting this
odd behavior of only executing the commands that I did not edit.  Our SA's
know nothing about 'AT' so they are of no help.
Has anyone else seen this odd behavior in the 'AT' function in Windoze?  I
know you find it hard to believe that something can be weird in Windoze.
;o)
And yes, I am soon planning on learning RMAN and do hot backups.  I have the
8i Backup and Recovery Handbook for my reading pleasure.  I see the app that
is being used going to a 24X7 schedule.  Now it is only used during the day.

Thanks,

Dave
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Farnsworth, Dave
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--
Live Life in Broadband
www.telewest.co.uk


The information transmitted is intended only for the person or entity to which it is 
addressed and may contain confidential and/or privileged material.
Statements and opinions expressed in this e-mail may not represent those of the 
company. Any review, retransmission, dissemination or other use of, or taking of any 
action in reliance upon, this information by persons or entities other than the 
intended recipient is prohibited. If you received this in error, please contact the 
sender immediately and delete the material from any computer.


==

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Adrian Roe
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: Weird Windoze 'AT' Behavior

2002-07-17 Thread Boivin, Patrice J

Which editor did you use to edit your batch file?

WordPad and Notepad don't behave the same way.

Open the file in wordpad and in notepad, to see if it looks the same in
both.

Beware of tabs, unicode, and the two different EOL characters.  Wordpad
sometimes uses a different end-of-line character than notepad.  Notepad
sometimes saves things in unicode.

Also make sure you change the explorer settings to show file name
extensions, show all files, etc.  sometimes one of the editors (not sure if
it's wordpad or notepad) saves files with .txt at the end, even though you
specify an extension in the Save As filename box.  e.g. you can end up with
files named job.txt.txt.

Save things in plain text, avoid word format, but you probably know that
already.

HTH

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin  Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]


 -Original Message-
Sent:   Wednesday, July 17, 2002 10:43 AM
To: Multiple recipients of list ORACLE-L
Subject:Weird Windoze 'AT'  Behavior

I have Oracle 8.1.7 running on NT.  I do cold backups nightly and have a
batch file that is called by the NT 'AT' scheduler.  I recently changed some
lines of commands in the batch file and since then when the batch file is
executed by 'AT' only the lines that I did not edit are executed.
If I execute the batch file from the command prompt it works fine.  I
deleted the job from 'AT' and then entered it back in but still getting this
odd behavior of only executing the commands that I did not edit.  Our SA's
know nothing about 'AT' so they are of no help.
Has anyone else seen this odd behavior in the 'AT' function in Windoze?  I
know you find it hard to believe that something can be weird in Windoze.
;o)
And yes, I am soon planning on learning RMAN and do hot backups.  I have the
8i Backup and Recovery Handbook for my reading pleasure.  I see the app that
is being used going to a 24X7 schedule.  Now it is only used during the day.

Thanks,

Dave
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Farnsworth, Dave
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: Weird Windoze 'AT' Behavior

2002-07-17 Thread Farnsworth, Dave

Yep, it has the full path and name.  It still only executes some of the lines of code. 
 I would expect that it execute the whole file or non of the file.  I bounced the 
server so I'll see if that helps.

Thanks,

Dave

-Original Message-
Sent: Wednesday, July 17, 2002 10:14 AM
To: Multiple recipients of list ORACLE-L


Have you fully qualified the path to the batch file ? Maybe the previous
batch file been copied into another directory in the PATH and AT is finding
this one before it finds your edited file.

Ade

-Original Message-
Sent: 17 July 2002 14:43
To: Multiple recipients of list ORACLE-L


I have Oracle 8.1.7 running on NT.  I do cold backups nightly and have a
batch file that is called by the NT 'AT' scheduler.  I recently changed some
lines of commands in the batch file and since then when the batch file is
executed by 'AT' only the lines that I did not edit are executed.
If I execute the batch file from the command prompt it works fine.  I
deleted the job from 'AT' and then entered it back in but still getting this
odd behavior of only executing the commands that I did not edit.  Our SA's
know nothing about 'AT' so they are of no help.
Has anyone else seen this odd behavior in the 'AT' function in Windoze?  I
know you find it hard to believe that something can be weird in Windoze.
;o)
And yes, I am soon planning on learning RMAN and do hot backups.  I have the
8i Backup and Recovery Handbook for my reading pleasure.  I see the app that
is being used going to a 24X7 schedule.  Now it is only used during the day.

Thanks,

Dave
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Farnsworth, Dave
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--
Live Life in Broadband
www.telewest.co.uk


The information transmitted is intended only for the person or entity to which it is 
addressed and may contain confidential and/or privileged material.
Statements and opinions expressed in this e-mail may not represent those of the 
company. Any review, retransmission, dissemination or other use of, or taking of any 
action in reliance upon, this information by persons or entities other than the 
intended recipient is prohibited. If you received this in error, please contact the 
sender immediately and delete the material from any computer.


==

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Adrian Roe
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Farnsworth, Dave
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: Weird Windoze 'AT' Behavior

2002-07-17 Thread Hayes, Scott

One problem that I have had with the 'AT' command is the you cannot use UNC
namimg when doing a copy, you have to use a mapped drive. This is a
documented 'feature' of the 'AT' command.

Example:
copy stuff to \\server\backup_dir  -- does not work
net use f: \\server\backup_dir
copy stuff to f:  -- Works

Good luck,

Scott



I have Oracle 8.1.7 running on NT.  I do cold backups nightly and have a
batch file that is called by the NT 'AT' scheduler.  I recently changed some
lines of commands in the batch file and since then when the batch file is
executed by 'AT' only the lines that I did not edit are executed.
If I execute the batch file from the command prompt it works fine.  I
deleted the job from 'AT' and then entered it back in but still getting this
odd behavior of only executing the commands that I did not edit.  Our SA's
know nothing about 'AT' so they are of no help.
Has anyone else seen this odd behavior in the 'AT' function in Windoze?  I
know you find it hard to believe that something can be weird in Windoze.
;o)
And yes, I am soon planning on learning RMAN and do hot backups.  I have the
8i Backup and Recovery Handbook for my reading pleasure.  I see the app that
is being used going to a 24X7 schedule.  Now it is only used during the day.

Thanks,

Dave
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Farnsworth, Dave
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


--
Live Life in Broadband
www.telewest.co.uk


The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material.
Statements and opinions expressed in this e-mail may not represent those of
the company. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender immediately and delete the material
from any computer.



==

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Adrian Roe
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hayes, Scott
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: Weird Windoze 'AT' Behavior

2002-07-17 Thread Bishop Lewis

The Scheduler is installed with IE5.5 - definitively worth the install.

As far as executing some lines but not others - it sounds like a environment
variable problem to me - put a set command (to list variables and a pause
command in your script (or output a log file) and check that your
environmental settings are okay.

Lewis Bishop
---
Oracle Database Consultant - Barclays Enable/ISS/OpenPlan 
Email:  [EMAIL PROTECTED]



-Original Message-
Sent: 17 July 2002 16:14
To: Multiple recipients of list ORACLE-L


This header confirms that this email message has been swept for the
presence of computer viruses. 

Corporate IT
THE WOOLWICH
--

Dave,

I've found AT to be flakey at best.  I haven't had your specific problem,
but I have had problems where AT would only occasionally run when it was
supposed to.

I don't remember if it was a specific NT patch or a version of IE explorer,
but one of these will install a Scheduler utility, which I've found to be
pretty reliable.  If you open My Computer (or explorer) you should see a
folder called Scheduled Tasks.  Double-click and then use the wizard to set
up a call to your batch file.

HTH,
-- 

Alan Davey
[EMAIL PROTECTED]
212-604-0200  x106


On 7/17/02, Farnsworth, Dave [EMAIL PROTECTED] wrote:
I have Oracle 8.1.7 running on NT.  I do cold backups nightly and 
have a batch file that is called by the NT 'AT' scheduler.  I recently 
changed some lines of commands in the batch file and since then when 
the batch file is executed by 'AT' only the lines that I did not 
edit are executed.
If I execute the batch file from the command prompt it works fine. 
 I deleted the job from 'AT' and then entered it back in but still 
getting this odd behavior of only executing the commands that I did 
not edit.  Our SA's know nothing about 'AT' so they are of no help.
Has anyone else seen this odd behavior in the 'AT' function in Windoze? 
 I know you find it hard to believe that something can be weird in 
Windoze.  ;o)
And yes, I am soon planning on learning RMAN and do hot backups. 
 I have the 8i Backup and Recovery Handbook for my reading pleasure. 
 I see the app that is being used going to a 24X7 schedule.  Now 
it is only used during the day.

Thanks,

Dave
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Farnsworth, Dave
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing 
Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and 
in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Alan Davey
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


The information, attachments and opinions contained in this message are those of its 
author only and do not necessarily represent those of The Woolwich and or any other 
members of the Barclays Group and are intended solely for the use of the individual or 
entity to whom they are addressed. The sender may not be authorised to give financial 
advice, and nothing in this message should be construed as offering such advice.

The message may contain privileged and confidential information and you may not copy, 
distribute or take any action in reliance on it. If you have received this email in 
error please notify the Information Security Manager at [EMAIL PROTECTED]

Replies to this email may be monitored for operational or business reasons.

Woolwich plc. Registered in England Number : 3295699.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bishop Lewis
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed 

Re: Weird Windoze 'AT' Behavior

2002-07-17 Thread Igor Neyman

Dave,

What is the difference between the lines, that get executed and those that
don't.
Are you referencing mapped network drives in those lines that don't get
executed?
On NT AT job is executed by the NT Scheduler, which runs under local
SYSTEM account and does not have permissions to access network drives.
That's why you might see the difference, when you run batch file from the
dos prompt: you run it under your account, which probably has permissions to
access network drives.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 17, 2002 11:58 AM


Yep, it has the full path and name.  It still only executes some of the
lines of code.  I would expect that it execute the whole file or non of the
file.  I bounced the server so I'll see if that helps.

Thanks,

Dave

-Original Message-
Sent: Wednesday, July 17, 2002 10:14 AM
To: Multiple recipients of list ORACLE-L


Have you fully qualified the path to the batch file ? Maybe the previous
batch file been copied into another directory in the PATH and AT is finding
this one before it finds your edited file.

Ade

-Original Message-
Sent: 17 July 2002 14:43
To: Multiple recipients of list ORACLE-L


I have Oracle 8.1.7 running on NT.  I do cold backups nightly and have a
batch file that is called by the NT 'AT' scheduler.  I recently changed some
lines of commands in the batch file and since then when the batch file is
executed by 'AT' only the lines that I did not edit are executed.
If I execute the batch file from the command prompt it works fine.  I
deleted the job from 'AT' and then entered it back in but still getting this
odd behavior of only executing the commands that I did not edit.  Our SA's
know nothing about 'AT' so they are of no help.
Has anyone else seen this odd behavior in the 'AT' function in Windoze?  I
know you find it hard to believe that something can be weird in Windoze.
;o)
And yes, I am soon planning on learning RMAN and do hot backups.  I have the
8i Backup and Recovery Handbook for my reading pleasure.  I see the app that
is being used going to a 24X7 schedule.  Now it is only used during the day.

Thanks,

Dave
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Farnsworth, Dave
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


--
Live Life in Broadband
www.telewest.co.uk


The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material.
Statements and opinions expressed in this e-mail may not represent those of
the company. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender immediately and delete the material
from any computer.



==

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Adrian Roe
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Farnsworth, Dave
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: 

RE: Weird Windoze 'AT' Behavior

2002-07-17 Thread Khedr, Waleed

Did you check the event viewer Application log  System log for any
unanticipated errors?

Waleed

-Original Message-
Sent: Wednesday, July 17, 2002 11:59 AM
To: Multiple recipients of list ORACLE-L


Yep, it has the full path and name.  It still only executes some of the
lines of code.  I would expect that it execute the whole file or non of the
file.  I bounced the server so I'll see if that helps.

Thanks,

Dave

-Original Message-
Sent: Wednesday, July 17, 2002 10:14 AM
To: Multiple recipients of list ORACLE-L


Have you fully qualified the path to the batch file ? Maybe the previous
batch file been copied into another directory in the PATH and AT is finding
this one before it finds your edited file.

Ade

-Original Message-
Sent: 17 July 2002 14:43
To: Multiple recipients of list ORACLE-L


I have Oracle 8.1.7 running on NT.  I do cold backups nightly and have a
batch file that is called by the NT 'AT' scheduler.  I recently changed some
lines of commands in the batch file and since then when the batch file is
executed by 'AT' only the lines that I did not edit are executed.
If I execute the batch file from the command prompt it works fine.  I
deleted the job from 'AT' and then entered it back in but still getting this
odd behavior of only executing the commands that I did not edit.  Our SA's
know nothing about 'AT' so they are of no help.
Has anyone else seen this odd behavior in the 'AT' function in Windoze?  I
know you find it hard to believe that something can be weird in Windoze.
;o)
And yes, I am soon planning on learning RMAN and do hot backups.  I have the
8i Backup and Recovery Handbook for my reading pleasure.  I see the app that
is being used going to a 24X7 schedule.  Now it is only used during the day.

Thanks,

Dave
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Farnsworth, Dave
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


--
Live Life in Broadband
www.telewest.co.uk


The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material.
Statements and opinions expressed in this e-mail may not represent those of
the company. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender immediately and delete the material
from any computer.



==

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Adrian Roe
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Farnsworth, Dave
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Khedr, Waleed
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line 

RE: Weird Windoze 'AT' Behavior

2002-07-17 Thread Jeff Herrick


In the same veinif it's a system level environment variable
that has been added since reboot, then you need a reboot of the server.
Simply starting and stopping the Scheduler service is not enough since
the scheduler service inherits its environment from the Service Control
manager (Services.exe) which only reads its environment at system
boottime.

Cheers

Jeff Herrick

On Wed, 17 Jul 2002, Bishop Lewis wrote:

 The Scheduler is installed with IE5.5 - definitively worth the install.

 As far as executing some lines but not others - it sounds like a environment
 variable problem to me - put a set command (to list variables and a pause
 command in your script (or output a log file) and check that your
 environmental settings are okay.

 Lewis Bishop
 ---
 Oracle Database Consultant - Barclays Enable/ISS/OpenPlan
 Email:[EMAIL PROTECTED]



 -Original Message-
 Sent: 17 July 2002 16:14
 To: Multiple recipients of list ORACLE-L


 This header confirms that this email message has been swept for the
 presence of computer viruses.

 Corporate IT
 THE WOOLWICH
 --

 Dave,

 I've found AT to be flakey at best.  I haven't had your specific problem,
 but I have had problems where AT would only occasionally run when it was
 supposed to.

 I don't remember if it was a specific NT patch or a version of IE explorer,
 but one of these will install a Scheduler utility, which I've found to be
 pretty reliable.  If you open My Computer (or explorer) you should see a
 folder called Scheduled Tasks.  Double-click and then use the wizard to set
 up a call to your batch file.

 HTH,
 --

 Alan Davey
 [EMAIL PROTECTED]
 212-604-0200  x106


 On 7/17/02, Farnsworth, Dave [EMAIL PROTECTED] wrote:
 I have Oracle 8.1.7 running on NT.  I do cold backups nightly and
 have a batch file that is called by the NT 'AT' scheduler.  I recently
 changed some lines of commands in the batch file and since then when
 the batch file is executed by 'AT' only the lines that I did not
 edit are executed.
 If I execute the batch file from the command prompt it works fine.
  I deleted the job from 'AT' and then entered it back in but still
 getting this odd behavior of only executing the commands that I did
 not edit.  Our SA's know nothing about 'AT' so they are of no help.
 Has anyone else seen this odd behavior in the 'AT' function in Windoze?
  I know you find it hard to believe that something can be weird in
 Windoze.  ;o)
 And yes, I am soon planning on learning RMAN and do hot backups.
  I have the 8i Backup and Recovery Handbook for my reading pleasure.
  I see the app that is being used going to a 24X7 schedule.  Now
 it is only used during the day.
 
 Thanks,
 
 Dave
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Farnsworth, Dave
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing
 Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
 in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
 

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Alan Davey
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


 The information, attachments and opinions contained in this message are those of its 
author only and do not necessarily represent those of The Woolwich and or any other 
members of the Barclays Group and are intended solely for the use of the individual 
or entity to whom they are addressed. The sender may not be authorised to give 
financial advice, and nothing in this message should be construed as offering such 
advice.

 The message may contain privileged and confidential information and you may not 
copy, distribute or take any action in reliance on it. If you have received this 
email in error please notify the Information Security Manager at 
[EMAIL PROTECTED]

 Replies to this email may be monitored for operational or business reasons.

 Woolwich plc. Registered in England Number : 3295699.

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: 

RE: Weird Windoze 'AT' Behavior

2002-07-17 Thread Farnsworth, Dave

That is it exactly!!  I have a few lines that do a XCOPY command to copy my database 
files to another server.  Previously I had the backup going to a local drive.  Now I 
have a server that I am getting all my database backups going to.  Will it work if the 
drive is a mapped drive on the Oracle server?

Dave

-Original Message-
Sent: Wednesday, July 17, 2002 11:25 AM
To: Multiple recipients of list ORACLE-L


Dave,

What is the difference between the lines, that get executed and those that
don't.
Are you referencing mapped network drives in those lines that don't get
executed?
On NT AT job is executed by the NT Scheduler, which runs under local
SYSTEM account and does not have permissions to access network drives.
That's why you might see the difference, when you run batch file from the
dos prompt: you run it under your account, which probably has permissions to
access network drives.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 17, 2002 11:58 AM


Yep, it has the full path and name.  It still only executes some of the
lines of code.  I would expect that it execute the whole file or non of the
file.  I bounced the server so I'll see if that helps.

Thanks,

Dave

-Original Message-
Sent: Wednesday, July 17, 2002 10:14 AM
To: Multiple recipients of list ORACLE-L


Have you fully qualified the path to the batch file ? Maybe the previous
batch file been copied into another directory in the PATH and AT is finding
this one before it finds your edited file.

Ade

-Original Message-
Sent: 17 July 2002 14:43
To: Multiple recipients of list ORACLE-L


I have Oracle 8.1.7 running on NT.  I do cold backups nightly and have a
batch file that is called by the NT 'AT' scheduler.  I recently changed some
lines of commands in the batch file and since then when the batch file is
executed by 'AT' only the lines that I did not edit are executed.
If I execute the batch file from the command prompt it works fine.  I
deleted the job from 'AT' and then entered it back in but still getting this
odd behavior of only executing the commands that I did not edit.  Our SA's
know nothing about 'AT' so they are of no help.
Has anyone else seen this odd behavior in the 'AT' function in Windoze?  I
know you find it hard to believe that something can be weird in Windoze.
;o)
And yes, I am soon planning on learning RMAN and do hot backups.  I have the
8i Backup and Recovery Handbook for my reading pleasure.  I see the app that
is being used going to a 24X7 schedule.  Now it is only used during the day.

Thanks,

Dave
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Farnsworth, Dave
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


--
Live Life in Broadband
www.telewest.co.uk


The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material.
Statements and opinions expressed in this e-mail may not represent those of
the company. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender immediately and delete the material
from any computer.



==

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Adrian Roe
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Farnsworth, Dave
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

RE: Weird Windoze 'AT' Behavior

2002-07-17 Thread Mark Leith

Dave, try WinCron.. Pretty cheap and apparently more reliable..

http://www.wincron.co.uk

M.

-Original Message-
Dave
Sent: 17 July 2002 16:59
To: Multiple recipients of list ORACLE-L


Yep, it has the full path and name.  It still only executes some of the
lines of code.  I would expect that it execute the whole file or non of the
file.  I bounced the server so I'll see if that helps.

Thanks,

Dave

-Original Message-
Sent: Wednesday, July 17, 2002 10:14 AM
To: Multiple recipients of list ORACLE-L


Have you fully qualified the path to the batch file ? Maybe the previous
batch file been copied into another directory in the PATH and AT is finding
this one before it finds your edited file.

Ade

-Original Message-
Sent: 17 July 2002 14:43
To: Multiple recipients of list ORACLE-L


I have Oracle 8.1.7 running on NT.  I do cold backups nightly and have a
batch file that is called by the NT 'AT' scheduler.  I recently changed some
lines of commands in the batch file and since then when the batch file is
executed by 'AT' only the lines that I did not edit are executed.
If I execute the batch file from the command prompt it works fine.  I
deleted the job from 'AT' and then entered it back in but still getting this
odd behavior of only executing the commands that I did not edit.  Our SA's
know nothing about 'AT' so they are of no help.
Has anyone else seen this odd behavior in the 'AT' function in Windoze?  I
know you find it hard to believe that something can be weird in Windoze.
;o)
And yes, I am soon planning on learning RMAN and do hot backups.  I have the
8i Backup and Recovery Handbook for my reading pleasure.  I see the app that
is being used going to a 24X7 schedule.  Now it is only used during the day.

Thanks,

Dave
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Farnsworth, Dave
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


--
Live Life in Broadband
www.telewest.co.uk


The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material.
Statements and opinions expressed in this e-mail may not represent those of
the company. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender immediately and delete the material
from any computer.



==

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Adrian Roe
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Farnsworth, Dave
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark Leith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L

Re: Weird Windoze 'AT' Behavior

2002-07-17 Thread Igor Neyman

Not sure about mapped drives, just try it.
If it wouldn't work, try to change Task Scheduler service startup
options (through ControlPanel/Services) to run under some account, which has
privileges to access network drives, instead of running under local SYSTEM
account.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 17, 2002 12:47 PM


That is it exactly!!  I have a few lines that do a XCOPY command to copy my
database files to another server.  Previously I had the backup going to a
local drive.  Now I have a server that I am getting all my database backups
going to.  Will it work if the drive is a mapped drive on the Oracle server?

Dave

-Original Message-
Sent: Wednesday, July 17, 2002 11:25 AM
To: Multiple recipients of list ORACLE-L


Dave,

What is the difference between the lines, that get executed and those that
don't.
Are you referencing mapped network drives in those lines that don't get
executed?
On NT AT job is executed by the NT Scheduler, which runs under local
SYSTEM account and does not have permissions to access network drives.
That's why you might see the difference, when you run batch file from the
dos prompt: you run it under your account, which probably has permissions to
access network drives.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 17, 2002 11:58 AM


Yep, it has the full path and name.  It still only executes some of the
lines of code.  I would expect that it execute the whole file or non of the
file.  I bounced the server so I'll see if that helps.

Thanks,

Dave

-Original Message-
Sent: Wednesday, July 17, 2002 10:14 AM
To: Multiple recipients of list ORACLE-L


Have you fully qualified the path to the batch file ? Maybe the previous
batch file been copied into another directory in the PATH and AT is finding
this one before it finds your edited file.

Ade

-Original Message-
Sent: 17 July 2002 14:43
To: Multiple recipients of list ORACLE-L


I have Oracle 8.1.7 running on NT.  I do cold backups nightly and have a
batch file that is called by the NT 'AT' scheduler.  I recently changed some
lines of commands in the batch file and since then when the batch file is
executed by 'AT' only the lines that I did not edit are executed.
If I execute the batch file from the command prompt it works fine.  I
deleted the job from 'AT' and then entered it back in but still getting this
odd behavior of only executing the commands that I did not edit.  Our SA's
know nothing about 'AT' so they are of no help.
Has anyone else seen this odd behavior in the 'AT' function in Windoze?  I
know you find it hard to believe that something can be weird in Windoze.
;o)
And yes, I am soon planning on learning RMAN and do hot backups.  I have the
8i Backup and Recovery Handbook for my reading pleasure.  I see the app that
is being used going to a 24X7 schedule.  Now it is only used during the day.

Thanks,

Dave
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Farnsworth, Dave
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


--
Live Life in Broadband
www.telewest.co.uk


The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material.
Statements and opinions expressed in this e-mail may not represent those of
the company. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender immediately and delete the material
from any computer.



==

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Adrian Roe
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line 

Re: Weird Windoze 'AT' Behavior

2002-07-17 Thread James J. Morrow

You may want to check a couple of things:

1.  Be careful which editor you use.  (Consider locating an old copy of the
MS-DOS QEdit
shareware program.  It's small, and very clean).  Or, use the DOS EDIT
utility.  (If you
feel the need for a windows editor, notepad is probably your cleanest
choice.)

2.  DOS sometimes needs an end-of-file marker (Ctrl-Z).  Some things won't
recognize the last
line without it.

3.  Or, if you're a *nix bigot like me, install cygwin (http://www.cygwin.com). 
You'll get a 
unix-like cron utility as well as some decent scripting tools...

Farnsworth, Dave wrote:
 
 I have Oracle 8.1.7 running on NT.  I do cold backups nightly and have a batch file 
that is called by the NT 'AT' scheduler.  I recently changed some lines of commands 
in the batch file and since then when the batch file is executed by 'AT' only the 
lines that I did not edit are executed.
 If I execute the batch file from the command prompt it works fine.  I deleted the 
job from 'AT' and then entered it back in but still getting this odd behavior of only 
executing the commands that I did not edit.  Our SA's know nothing about 'AT' so they 
are of no help.
 Has anyone else seen this odd behavior in the 'AT' function in Windoze?  I know you 
find it hard to believe that something can be weird in Windoze.  ;o)
 And yes, I am soon planning on learning RMAN and do hot backups.  I have the 8i 
Backup and Recovery Handbook for my reading pleasure.  I see the app that is being 
used going to a 24X7 schedule.  Now it is only used during the day.
 
 Thanks,
 
 Dave
-- James

James J. Morrow E-Mail:  [EMAIL PROTECTED]
Senior Principal Consultant
Tenure Systems, Inc.
McKinney, TX, USA

The reasonable man adapts himself to the world:  the unreasonable man
  persists in trying to adapt the world to himself.  Therefore all progress
   depends on the unreasonable man.  -- George Bernard Shaw
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: James J. Morrow
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: Weird Windoze 'AT' Behavior

2002-07-17 Thread Hayes, Scott

Yes :)

Scott

-Original Message-
Sent: Wednesday, July 17, 2002 12:47 PM
To: Multiple recipients of list ORACLE-L


That is it exactly!!  I have a few lines that do a XCOPY command to copy my
database files to another server.  Previously I had the backup going to a
local drive.  Now I have a server that I am getting all my database backups
going to.  Will it work if the drive is a mapped drive on the Oracle server?

Dave

-Original Message-
Sent: Wednesday, July 17, 2002 11:25 AM
To: Multiple recipients of list ORACLE-L


Dave,

What is the difference between the lines, that get executed and those that
don't.
Are you referencing mapped network drives in those lines that don't get
executed?
On NT AT job is executed by the NT Scheduler, which runs under local
SYSTEM account and does not have permissions to access network drives.
That's why you might see the difference, when you run batch file from the
dos prompt: you run it under your account, which probably has permissions to
access network drives.

Igor Neyman, OCP DBA
[EMAIL PROTECTED]


- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 17, 2002 11:58 AM


Yep, it has the full path and name.  It still only executes some of the
lines of code.  I would expect that it execute the whole file or non of the
file.  I bounced the server so I'll see if that helps.

Thanks,

Dave

-Original Message-
Sent: Wednesday, July 17, 2002 10:14 AM
To: Multiple recipients of list ORACLE-L


Have you fully qualified the path to the batch file ? Maybe the previous
batch file been copied into another directory in the PATH and AT is finding
this one before it finds your edited file.

Ade

-Original Message-
Sent: 17 July 2002 14:43
To: Multiple recipients of list ORACLE-L


I have Oracle 8.1.7 running on NT.  I do cold backups nightly and have a
batch file that is called by the NT 'AT' scheduler.  I recently changed some
lines of commands in the batch file and since then when the batch file is
executed by 'AT' only the lines that I did not edit are executed.
If I execute the batch file from the command prompt it works fine.  I
deleted the job from 'AT' and then entered it back in but still getting this
odd behavior of only executing the commands that I did not edit.  Our SA's
know nothing about 'AT' so they are of no help.
Has anyone else seen this odd behavior in the 'AT' function in Windoze?  I
know you find it hard to believe that something can be weird in Windoze.
;o)
And yes, I am soon planning on learning RMAN and do hot backups.  I have the
8i Backup and Recovery Handbook for my reading pleasure.  I see the app that
is being used going to a 24X7 schedule.  Now it is only used during the day.

Thanks,

Dave
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Farnsworth, Dave
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


--
Live Life in Broadband
www.telewest.co.uk


The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material.
Statements and opinions expressed in this e-mail may not represent those of
the company. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender immediately and delete the material
from any computer.



==

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Adrian Roe
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Farnsworth, Dave
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858)