Re: Script to check exports
Date: Mon, 7 Jul 2008 15:24:49 +1000
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. <http://www.imtalkathon.com/?source=EML_WLH_Talkathon_ChangeWorld>
-- J.A. van Zanen -- http://www.freelists.org/webpage/oracle-lReceived on Mon Jul 07 2008 - 00:24:49 CDT