Re: Job schedule

From: Connor McDonald <hamcdc_at_yahoo.co.uk>
Date: Fri, 4 Feb 2005 00:40:38 +0000 (GMT)
Message-ID: <20050204004038.49932.qmail@web86902.mail.ukl.yahoo.com>

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_at_usa.net> 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_at_ge.com>
> To: <Oracle-L_at_freelists.org>
> 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_at_yahoo.com

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

Received on Thu Feb 03 2005 - 19:43:18 CST