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

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 - 14:43:52 CDT