Re: Scheduling Stored Procedures

From: Mike Ong-Tone <ongtone_at_home.com>
Date: 2000/07/08
Message-ID: <M8G95.26931$ZI2.1255664_at_news1.rdc1.on.wave.home.com>#1/1

Use the DBMS_JOB package procedure.

"LF" <frolio_at_home.com> wrote in message news:TAd85.5570$cu1.13149_at_news1.rdc1.ct.home.com...
> Greetings All, I have a procedure that I want to run at the same
> time each night and I am not sure how to do this via Oracle. In
> SQL Server this was done via 'Jobs', in Oracle I cannot find and
> analog. Can anyone tell me how to tell Oracle to run a certain procedure
> at a given time on a given day?
>
> Any help would be greatly appreciated.
>
> L
>
>
Received on Sat Jul 08 2000 - 00:00:00 CEST

This message: [ Message body ]
Next message: Dickie Siu: "Re: How to handle return type of Table%RowType in Store Procedure by JDBC"
Previous message: Will Lusted: "Re: Can you call Oracle triggers from VB?"
In reply to: LF: "Scheduling Stored Procedures"
In reply to LF: "Scheduling Stored Procedures"
Next in thread: Dickie Siu: "Re: How to handle return type of Table%RowType in Store Procedure by JDBC"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message