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: NT/2000 schedulable Process

Re: NT/2000 schedulable Process

From: Terry Dykstra <dontreply_tddykstra_at_forestoil.ca>
Date: Fri, 22 Feb 2002 17:55:06 GMT
Message-ID: <_Bvd8.29812$Ym3.4472746@news0.telusplanet.net>


On W2K you should use the Task Scheduler instead of AT. It's more robust. I use the Cygwin utilities for my Oracle scripting on NT/W2K. http://www.cygwin.com

--
Terry Dykstra
Canadian Forest Oil Ltd.
"Fraser McCallum" <fmcc_at_NOSPAModbaguru.com> wrote in message
news:qhgd8.21852$kX6.165104_at_NewsReader...

> NT's equivalent of CRON is the AT command. That plus a script file with
the
> sqlplus and system commands in it should do the job. If it's an existing
dB
> check they probably have scripts for doing the backups etc, you could get
> some ideas from them.
>
> Regards
>
> Fraser McCallum
> MVP Oracle Administration
> www.brainbench.com
>
> "Rom" <orom_at_systec.com> wrote in message
> news:a53unt01lgv_at_enews1.newsguy.com...
> > Hi,
> >
> > Most of my work involves Unix servers, but now I have to prepare a
process
> > on NT.
> > The process should log in to Oracle, execute one SQL statement, log out,
> > perform some system functions, log in again and execute another
statement.
> > I need this process to be schedulable.
> >
> > Is there an easy way to do that?
> >
> > Thanks for your help.
> >
> > Ofer Rom, DBA(OCP)
> >
> >
> >
> >
>
>
Received on Fri Feb 22 2002 - 11:55:06 CST

Original text of this message

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