Everyday we get some copies of the production database for our development environment. The name of the copy is the type of backup + timestamp. (example: PRD_backup_201010042130.DBB) This means that the name of the file is/should be changing every day. Because the backup copy action sometimes fails, I would like to monitor the file, so I can sent an alarm notification to the dba if the copy fails and it would be nice to collect some statistics to see how often it goes wrong. The problem is that I don't know how to monitor a file with a changing name. Is it possible to use wildcards in some way? Is there a custom sensor that allows me to monitor files with changing names or could someone help me with a wmi script if that is even possible?

Thanks in advance!

Article Comments

Hallo,

create a folder sensor that monitors the folder the file goes into.

Mack the channel Newest File your primary channel.

go to channels and enable limits for that channel and edit the limits in that way that it is an error if the newest file is older than one day.

Or let the sensor enter a warning state after one day and an error state after 1,5 days

Then go to the notifications tab and your state triggers.


Oct, 2010 - Permalink