Re: Sheduling Oracle Jobs from WIN NT 4.0

In article <60ufqc$66d$1_at_galaxy.us.dell.com>, "Carlos A. Gonzalez" <carlos_a_gonzalez_at_us.dell.com> wrote:
> Gentlemen:
>
>How could I schedule an Oracle job to run a procedure (from whithin the
>database) in Win NT ver 4.0.

Well, one way would be to schedule it as a DOS job using the DOS/WinNT command line program AT, load SQL*Plus with command line parameters of your connect string and exec call to the procedure or to a SQL or PL/SQL script, in the form:

AT 12:00 every M, W, F c:\orant\bin\plus32 scott/tiger_at_orcl @c:\orant\bin\execproc.sql

If AT doesn't want to swallow this, create a batch file called, say, "execproc.cmd" that consists of the line:

 c:\orant\bin\plus32 scott/tiger_at_orcl @c:\orant\bin\execproc.sql

..and call it with the DOS command

AT 12:00 every M, W, F c:\orant\bin\execproc.cmd

So what you're scheduling is an NT job (you have to have the Schedule service started for this to work) that executes Oracle commands.

There may be other ways to do this.

Loren

--
Loren Davidson      
loren A T wombat D O T net         http://www.batnet.com/beauty/
The address in From and Reply To uses SPAM filters
"The future isn't what it used to be" -- Amb. G'Kar