Re: Job_Queue_Interval Parameters

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Mon, 17 Jan 2005 14:20:29 -0800
Message-ID: <41ec3a20$1_1@127.0.0.1>

bionicbabes_at_hotmail.com wrote:

> Hello,
>
> I have a job auto_access the interval parameter is currently
> SYSDATE+0.5/24. This runs the job every 30 minutes 24 hours per day.
> How can I make this job start at 09:00 (every 30 mins) finish 18:30?
> Many Thanks
>
> Rebecca

The starting is easy ... TRUNC(SYSDATE)+ It will end whenever it ends.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---

Received on Mon Jan 17 2005 - 16:20:29 CST