Re: Scheduling Batch jobs in NT
Date: Mon, 16 Sep 2002 03:03:19 GMT
Message-ID: <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 Mon Sep 16 2002 - 05:03:19 CEST