Re: Daily procedures - what are current best practices?

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Mon, 08 May 2006 17:13:15 GMT
Message-Id: <pan.2006.05.08.17.13.15.837072@sbcglobal.net>

On Mon, 08 May 2006 16:04:32 +0000, HansF wrote:

> What are the daily/weekly/monthly 'best practices' being used in various
> oranizations o keep on top of the health of their database environments?

So far, it is a combination of DBMS_JOB and cron. Purely database jobs like analyzing statistics, load from external tables into real tables (ETL) and populating aggregate tables is done by PL/SQL scripts/procedures invoked from DBMS_JOB. Producing actual reports and dealing with OS files is performed by jobs in crontab.

-- 
http://www.mgogala.com

Received on Mon May 08 2006 - 12:13:15 CDT