Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: NT/2000 schedulable Process
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...Received on Fri Feb 22 2002 - 11:55:06 CST
> 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)
> >
> >
> >
> >
>
>