peleg (11/8/2010)
the only thing that i whould change, is running the vbs from windows schedule task and not from the sql server, i think it's more correct way.This will give you the ability prepare a vbs that you can put on all of you server's, rather only in the db server (although you can query the event viewer of a remote server, which is little more work).
yes, you could use windows scheduler, however, since the DB is required to make it work, the script would have to include some logic to handle itself if the DB was not avaialble.
it is also designed to be used by a DBA. in some places, DBA's do not have access to the windows scheduler.
also, the script is only required on one server 😉