Automated Failed Script Alert

[lsmall]

Hi.

I am looking for some suggestions on how to set up a system to alert me of a failure in my script. I have a few ideas, but I'd like to hear what others might think.

I am running OS X 10.5.6 with FM 10 Adv on a dedicated computer. I have a second computer available to me with the same setup which is not dedicated to the database.

My script runs nightly between midnight and about 5am and is quite complex. Failures are infrequent, but if they occur they may be due to operator error (I forget to reset everything after I access the database during the day), a network problem, as the script needs to access a networked data source, or FM/the computer crashes.

I was thinking of incorporating an automated email that would be sent out every 15 minutes by the script. My other computer which is not really in use at night, can wait for these emails. If it doesn't receive an email within a half hour then it can automatically send an SMS message to my phone and wake me up to alert me to a problem.

Although, I'm sure it's possible to do, I have yet to figure out how to automate the Mail app to send out a message if it has not received a specific email message in a certain amount of time. This may be a better question for the Apple forums, but I would be curious if anyone had any thoughts or alternatives.

Thanks