RE: Script to check exports
- From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: <jack@xxxxxxxxxxxx>, <cemail_219@xxxxxxxxxxx>
- 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!
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jack van Zanen
Sent: Monday, July 07, 2008 1:25 AM
To: cemail_219@xxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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
Brgds
Jack
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@xxxxxxxxxxx> 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.
<http://www.imtalkathon.com/?source=EML_WLH_Talkathon_ChangeWorld>
--
J.A. van Zanen
Other related posts:
