Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: DBMS_JOB.INTERVAL help needed

Re: DBMS_JOB.INTERVAL help needed

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Sat, 26 Mar 2005 15:15:16 +0100
Message-ID: <42456e1c$0$32512$626a14ce@news.free.fr> 






"Rauf Sarwar" <rs_arwar_at_hotmail.com> a écrit dans le message de
news:1111843239.251202.199400_at_g14g2000cwa.googlegroups.com...



| If next interval is not too complicated, you could also make use of

| DECODE, TRUNC and simple date arithmatic to calculate next interval

| without resorting to PLSQL.

|

| Regards

| /Rauf




The advantage of using a function is that if you have to modify the schedule,
you just have to modify the function and not all the jobs based on this schedule.
Moreover, you can make calculation you can't explain with just basic functions
like decode and trunc.



Regards


Michel Cadot
Received on Sat Mar 26 2005 - 08:15:16 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US