I've basically adapted the PowerShell scripts that were supplied with update 4.0.2 SP3. See the attached txt file for the full script. You'll need to edit the script in notepad. Just do a find on "database_ID" and replace all instances with the identity of your database.
Create a new "Windows Script Monitor" Component monitor and paste your edited script into the body section.
Script Argument should be: /ServerName:"servername"
HTH
