Re: executing a stored procedure at a certain time

[Bunyamin K. Karadeniz]

Title: executing a stored procedure at a certain time

I 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. ----- Original Message ----- From: Igor Neyman To: Multiple recipients of list ORACLE-L Sent: Friday, April 19, 2002 11:13 PM Subject: Re: executing a stored procedure at a certain time Read on DBMS_JOB oracle-supplied package in docs.   Igor Neyman, OCP DBA [EMAIL PROTECTED]   ----- Original Message ----- From: Nelson Flores To: Multiple recipients of list ORACLE-L Sent: Friday, April 19, 2002 3:53 PM Subject: executing a stored procedure at a certain time 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 [EMAIL PROTECTED] --------------------------------------------------------------------------------------------------- Centro de tecnolog�as de Informaci�n  http://cti.intec.cl Corporaci�n de investigaci�n Tecnol�gica - Intec http://www.intec.cl ---------------------------------------------------------------------------------------------------