Custom Alert for Log backups of USERS dbs except SYSTEM dbs
new2sqlserver
Posts: 6
I just upgraded to V 3.0 and I know it has the capability to allow you create a custom alert through T-SQL query. Can anyone share a query to create a custom alert for monitoring log backup of ONLY USER databases not including SYSTEM databases. The current alert works for ALL databases and since I don't really backup logs for SYSTEM databases, I keep getting tons of alerts regarding the SYSTEM databases. Any ideas? Help is greatly appreciated.
Comments
How to do you modify existing alert? When I click on the alert all I see my options are is to enable or disable the alert. I don't see a modify or edit alert option. That was actually my initial idea which turns out to be the best for my circumstance. You're right, I'll not like to create a custom alert for this if I can easily modify an the existing alert.
Thanks for your quick response.
Here is some more information on configuration options:
http://www.red-gate.com/supportcenter/C ... 469820.htm