RE: Script to check for errors

2003-03-21 Thread Eberhard, Jeff
Here's what I use. Pretty basic (crappy) but may be a starting point for you. You'll have to go through and change where you alert files are stored and to whom to send the email. I schedule them to run about every 15 minutes. blat is a mail utility you can downloaded from the internet.

RE: Script to check for errors

2003-03-21 Thread Deshpande, Kirti
Check Tim Gorman's web site, http://www.evdbt.com/tools.htm. He has a script (chk_oerr.sh) to monitor alert.log for new ORA- errors and e-mail. You can see how it is done and come up with your own version for your own requirements. - Kirti -Original Message- Sent: Friday, March 21,

Re: Script to check for errors

2003-03-21 Thread Andy Rivenes
You can try a korn shell script called chkdberr.ksh at http://www.appsdba.com/scripts/chkdberr.ksh, it's already got the email built in. At 10:39 AM 3/21/2003 -0800, you wrote: Anyone have a simple script to scan an alert log for errors and email a report if found? Customer wants something to

RE: Script to check for errors

2003-03-21 Thread david hill
Here a fast little script I wrote that can be ran every minute Emails only when it finds a new message And pages if it finds a new message between 6pm and 5am FPATH=/prod/dba/scr autoload f_xmail logfile=/prod/dba/logs/`cat /prod/dba/sys_data/newpath`/misc_logs/chk_alerts.log

Re: Script to check for errors

2003-03-21 Thread Barbara Baker
Andy: This is a very cool script. Thanks very much!! Barb --- Andy Rivenes [EMAIL PROTECTED] wrote: You can try a korn shell script called chkdberr.ksh at http://www.appsdba.com/scripts/chkdberr.ksh, it's already got the email built in. At 10:39 AM 3/21/2003 -0800, you wrote: Anyone