Re: Job schedule

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 Received on Thu Feb 03 2005 - 11:21:50 CST