Re: dbms_job question

Uzytkownik "Ryan Gaffuri" <rgaffuri_at_cox.net> napisal w wiadomosci news:1efdad5b.0310230412.3b5b381f_at_posting.google.com...
> Is it possible to have a job run every 15 minutes between 7PM and 7AM
> every day accept sundays?

When job is run, the next run date is computed. You could use pl/sql function to compute next date.

function f_next_date(f_date DATE) RETURN DATE IS

BEGIN
 RETURN(f_date + 1/96);
END; Now, if you place that function as interval to job, your job will run every 15 minutes.
job_interval = f_next_date(sysdate);

All you need is modify that function, prevent it of returning a date which is Sunday :-)

--
Noel

How to set, modify job interval?
Take a close look at dmbs_job package.