Suspect database to send mail

[EBee]

How do I configure my SQL Mail to send mail/page messages when one of my databases goes "SUSPECT". I already have my SQL mail setup, i just can not find a error that sends this message out.

thanks

 

[JayKusch]

You may have to write a job that periodically polls the master..sysdatabases table for a database w/ status 32678.
when the status is found, then email the alert. trick would then be to set some type of flag once the email was sent so that other emails of the same error will not be sent out until the suspect DB issue is resolved.

Thanks

J. Kusch