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 hav

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 prob

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

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

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

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.

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.

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 n

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 environm

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:

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: Multip

RE: Weird Windoze 'AT' Behavior

2002-07-17 Thread Boivin, Patrice J
ents 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

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 hav

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, w

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 t

RE: Weird Windoze 'AT' Behavior

2002-07-17 Thread M B Shibu
Dave : Same thing happened to me . I have some batch files for daily export And rebuilds the index (runs only once in a week only )it stopped one day suddenly ..and when I scheduled it again .it started to work . No one knows why it stopped shibu -Original Message- F

Weird Windoze 'AT' Behavior

2002-07-17 Thread Farnsworth, Dave
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