Re: complex dbms jobs code

From: Jan van Mourik <jmourik_at_yahoo.com>
Date: 2 May 2002 13:57:54 -0700
Message-ID: <ffe966de.0205021257.52a73103@posting.google.com>

Take a look at Tom Kyte's website:

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:2668330597106

Or maybe you could submit two jobs, one for the whole hour with

interval:   'case when to_char(trunc(sysdate + 1/24),''D'') = 6 '


         ||   'then (NEXT_DAY(trunc(SYSDATE),''MONDAY'')+ 1/24) '

         ||   'else (trunc(sysdate,''hh24'') + 1/24) '

         || 'end'

and one for the half hour with
interval: 'case when to_char(trunc(sysdate,''hh24'') + 90/1440,''D'') = 6 '

|| 'then (NEXT_DAY(trunc(SYSDATE),''MONDAY'')+ 30/1440) '
|| 'else (trunc(sysdate,''hh24'') + 90/1440) '
|| 'end'

I couldn't get the whole thing in one interval, it was too large. The submit started complaining... Received on Thu May 02 2002 - 15:57:54 CDT