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 / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu
7.km Ankara
Title: executing a stored procedure at a certain time
Check
out Oracle jobs (dbms_jobs package). It's pretty easy.
Prakash
-Original Message-From: Nelson Flores
[mailto:[EMAIL PROTECTED]]Sent: Friday, April 19, 2002 3:53
PMTo: Multiple recipients of list ORACLE-LSu
ecipients of list ORACLE-L
> 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.
>
Title: executing a stored procedure at a certain time
You
can schedule it as a database job. Look into the dbms_job package and
section about database jobs
in the
admin guide.
-Original Message-From: Nelson Flores
[mailto:[EMAIL PROTECTED]]Sent: Friday, April 19, 2002 3:53
Title: executing a stored procedure at a certain time
Schedule the stored proc as a job using 'EXEC DBMS_JOB.SUBMIT'
Dave
-Original Message-From: Nelson Flores
[mailto:[EMAIL PROTECTED]]Sent: Friday, April 19, 2002 2:53
PMTo: Multiple recipients of list ORACL
Title: 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
Title: 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