Re: Job schedule
- From: "Terry Sutton" <terrysutton@xxxxxxx>
- To: <Oracle-L@xxxxxxxxxxxxx>
- Date: Thu, 3 Feb 2005 08:19:06 -0800
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
