RE: Script to check exports
Date: Mon, 7 Jul 2008 07:57:01 -0400
I do something very similar. I have a "job results" table that lists jobs and their execution schedule (daily, weekly, bi-weekly etc). When a job completes, it updates the record showing runtime and success/failure.
I have a daily job that looks at this table reporting failures only or jobs that are "late" (haven't run based on their schedule).
Very simple. Easy to maintain and it doesn't cost nothin!
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jack van Zanen Sent: Monday, July 07, 2008 1:25 AM
Subject: Re: Script to check exports
What we are using here is a very simple system.
We have scripted all backup and export jobs to add an entry in a database table. otther tables hold the backup and export schedules and we run daily checks against the two tables and a report of missed backups and exports comes out.
All we need to do is check the reports that come in the mail.
Setting this up should be fairly straight forward
May not be bulletproof (requires connection to another database) but so long as I have been here it seems to have been working quite reliable.
On 07/07/2008, J. Dex <cemail_219_at_hotmail.com> wrote:
Does anybody have a UNIX script that checks the filesystem to verify that an export actually ran and sends email notifications if it doesn't? I have a script that notifies if the export ran and an error was encountered, but what I am looking for now is a script that will send an email if there isn't an export there at all. In other words, I need to know if nightly exports have stopped running.
The i'm Talkaton. Can 30-days of conversation change the world?
Find out now.
-- J.A. van Zanen -- http://www.freelists.org/webpage/oracle-lReceived on Mon Jul 07 2008 - 06:57:01 CDT