Re: Scheduling Batch jobs in NT

why not just use dbms_job?

steve

"Michael J. Moore" <hicamel_x_the_spam_at_attbi.com> wrote in message news:<TRbh9.323652$_91.417542_at_rwcrnsc51.ops.asp.att.net>...
> Use OEM's job scheduler. It uses TCL and from the TCL script you can easily
> execute an SQLPLUS script.
> You can capture the output in the TCL script and Email it, or put it to
> file. Not only that, but you can point your script at any Oracle Instance
> running on Unix or NT, and it will run without changes.
> Mike
>
> "Shanthi" <ammu73_at_yahoo.com> wrote in message
> news:fce79f43.0209131211.1b2846c4_at_posting.google.com...
> > Hi,
> >
> > I am trying to schedule a Oracle SQL batch job on an NT machine. I am
> > not sure how I can write the batch job and schedule it too. What I
> > want is to write a batch job to call a particular SQL script and
> > execute it. The results need to be spooled to a text file. It would be
> > great if I can have the result file emailed to me too. Once the batch
> > job is written, how can I schedule it to run on NT? I have written
> > shell scripts to run jobs on Unix crons. I dont know how to write
> > batch jobs to run on NT. Thanks for all your help.
> >
> > -Shanthi
Received on Tue Sep 17 2002 - 20:58:53 CEST