Re: dbms_job question

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Fri, 24 Oct 2003 09:57:28 +0200
Message-ID: <bnam19$qep$1@news.fujitsu-siemens.com>

"Daniel Morgan" <damorgan_at_x.washington.edu> schrieb im Newsbeitrag news:1066940302.848416_at_yasure...
> 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.

Personally I'd like the fact that the sysadmin is responsible to make sure the cronjobs properly send their email. Much easier than using utl_smtp for it, especially if something goes wrong.

If I don't need notification and don't care if it fails occasionally (taking regular statspack snapshots for instance) I use dbms_jobs and check the log files and job views.

Lots of Greetings!
Volker Received on Fri Oct 24 2003 - 02:57:28 CDT