Like the idea.

I would suggest altering the script in the following ways

1. Read the website url's from a table

2. On success/fail write datetime and url and pass/fail to table for log purpose

3. On failure also send the email as you already do.

Might also be handy if different specific text on a website could be identified as either pass or fail (some websites do return pages when they are down)

Yes there are other tools that can do this, but would be handy if we can do it in SQL instead.

Thanks for sharing

Regards

Terry