Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Weird Windoze 'AT' Behavior
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 adavey_at_competitrack.com 212-604-0200 x106 On 7/17/02, Farnsworth, Dave <DFarnsworth_at_Ashleyfurniture.com> wrote:Received on Wed Jul 17 2002 - 10:13:31 CDT
>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: DFarnsworth_at_Ashleyfurniture.com
>
>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: ListGuru_at_fatcity.com (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: adavey_at_competitrack.com 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: ListGuru_at_fatcity.com (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).