Re: Job schedule

or you can tweak your job spec, ie

'if to_char(sysdate,'DY') in ('SAT','SUN','MON','TUE') then
    my_proc;
 end if;'

submitted to run once daily 

hth
connor

--- Terry Sutton <terrysutton@xxxxxxx> wrote:

> If you're using the dbms_job queue, your interval would be something like
>     'trunc(decode(to_char(sysdate,''DAY''), ''SATURDAY '', sysdate + 3,
> ''SUNDAY   '', sysdate + 2, sysdate + 1)) + 5/24'
> 
> The ''s are 2 single quotes.  There may be typos above, but you can test and
> experiment.
> 
> --Terry
> ----- Original Message ----- 
> From: "Aragon, Gabriel (GE Commercial Finance)" <gabriel.aragon@xxxxxx>
> To: <Oracle-L@xxxxxxxxxxxxx>
> Sent: Thursday, February 03, 2005 7:50 AM
> Subject: Job schedule
> 
> 
> Hi, basic question on jobs, how can I schedule a job to run from Tuesday =
> to Saturday at 5am?
> 
> regards,
> GAP
> --
> http://www.freelists.org/webpage/oracle-l
> 
> 
> --
> http://www.freelists.org/webpage/oracle-l
> 


=====
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
ISBN: 1590592174

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald@xxxxxxxxx

Coming Soon! "Oracle Insight - Tales of the OakTable"

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, 
and...he will sit in a boat and drink beer all day"

------------------------------------------------------------


                
__________________________________ 
Do you Yahoo!? 
The all-new My Yahoo! - Get yours free! 
http://my.yahoo.com 
 

--
http://www.freelists.org/webpage/oracle-l

Other related posts: