Re: dbms_job question

Ryan Gaffuri wrote:

>Is it possible to have a job run every 15 minutes between 7PM and 7AM
>every day accept sundays?
>
>

You but my feeling is that you should probably just run it every 15 minutes and make the
first statement in the procedure an IF statement that checks the clock to see when it is
appropriate to proceed.

With respect to Paddy's suggestion ... I'd avoid cron unless there was no other choice. Cron has
numerous problems as compared with DBMS_JOB. The least of which is that it requires involving
SysAdmins in everything you do.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)