Re: "OK" to loop on DBMS_SLEEP ???

Thanks.

What happened to requiring other skill sets you ask. It is hard enough to get just one. <g>

Daniel Morgan

Sean M wrote:

> Daniel Morgan wrote:
> >
> > I'm not the one with the issue but I hate cron. Error messaging is not nearly as
> > robust as what is possible with DBMS_JOB and it leaves the application's error
> > messages in multiple places. Also, it requires having one more skill set and more
> > privileges which means more things that can go wrong or be done poorly.
> >
> > Is there anything cron can do that DBMS_JOB with a bit of C or Java can't do
> > better?
>
> What happened to not requiring other skill sets and more privileges?
> Anyway, here's some tasks off the top of my head that are probably
> easier to schedule w/cron than dbms_job plus C/Java:
>
> - cold backups
> - hot backups when you need to sync the mirror before starting and spilt
> the mirror between the "alter tablespace begin/end backup" commands
> - monitoring the archive_dest freespace and cleaning up archived redo
> logs to tape as needed
>
> Regards,
> Sean
Received on Mon Apr 15 2002 - 16:02:22 CDT