Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: executing a stored procedure at a certain time
executing a stored procedure at a certain timeI do it in this way ..
Firstly ,
dbms_job.submit .... giving the interval ..
then
dbms_job.next_date ...
Bunyamin K. Karadeniz
Oracle DBA / Developer
Civilian IT Department
Havelsan A.S. Eskisehir yolu
7.km Ankara Turkey
Phone: +90 312 2873565 / 1217
Mobile : +90 535 3357729
The degree of normality in a database
is inversely proportional to that of its DBA.
Read on DBMS_JOB oracle-supplied package in docs.
Igor Neyman, OCP DBA
ineyman_at_perceptron.com
Hello everyone,
i was wondering if someone could tell me how set up an oracle internal mechanism that allows me
to execute an oracle stored proc. at a certain time every day.
thanks.
Atte.
Nelson Flores P.
Intec Project Manager
nflores_at_intec.cl
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bunyamin K. Karadeniz
INET: bunyamink_at_havelsan.com.tr
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Apr 22 2002 - 07:23:19 CDT
![]() |
![]() |