Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle/Unix shell script question...
In that case you can use the next_day function
"Marc Blum" <marc_at_marcblum.de> wrote in message
news:3c1cebbb.2591806_at_news.online.de...
> On 12 Dec 2001 12:39:49 +0200, costello_at_iki.fi (Antti
> =?iso-8859-1?q?J=E4rvinen?=) wrote:
>
> >If you always run your script on saturday and you want to use there
> >expression equivalent to "next saturday", you can express it simply
> >by saying "sysdate+7" which, if run today, '12-dec-2001' has value of
> >'19-dec-2001' e.g. next wednesday, 7 days ahead "sysdate". In some other
> >database than Oracle this might work in different way.
>
>
> But you have to be aware of the facts, that:
>
> - if the database was down for any reason, when the job had to be
> executed, Oracle will run it, when the database is up again.
>
> - Oracle determines the "next time" at the moment just before the job
> is executed.
>
> Conclusion: you have to build the rule to determine the "next time" in
> a way, that it always returns the next Saturday, not "today + 7 days"
>
> regards
> Marc Blum
> mailto:marc_at_marcblum.de
> http://www.marcblum.de
>
Received on Mon Dec 17 2001 - 11:34:18 CST