Red Gate forums :: View topic - Custom Alert for Log backups of USERS dbs except SYSTEM dbs
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 3
SQL Monitor 3 forum

Custom Alert for Log backups of USERS dbs except SYSTEM dbs

Search in SQL Monitor 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
new2sqlserver



Joined: 04 Apr 2012
Posts: 4

PostPosted: Wed Apr 04, 2012 3:34 pm    Post subject: Custom Alert for Log backups of USERS dbs except SYSTEM dbs Reply with quote

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.
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 327
Location: Cambridge, UK

PostPosted: Thu Apr 05, 2012 5:58 pm    Post subject: Reply with quote

You can modify the configuration for the existing alert on the SQL Server instance level or on the database level. So you can disable the alert for the system databases. While you may find that this is a little time consuming to do, it would be far easier than writing a custom metric and alert to do it.
_________________
Chris Kelly
Technical Support Engineer
Back to top
View user's profile Send private message
new2sqlserver



Joined: 04 Apr 2012
Posts: 4

PostPosted: Thu Apr 05, 2012 9:10 pm    Post subject: Custom Alert for Log backups of USERS dbs except SYSTEM dbs Reply with quote

Hi Chris,

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.
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 327
Location: Cambridge, UK

PostPosted: Tue Apr 10, 2012 12:24 pm    Post subject: Reply with quote

On the Alert Settings page (Configuration > Alert Settings is displayed at the top), there is a 'tree' on the left hand side displaying your monitored entities (and groups if appropriate). Select the level that you which to configure for, e.g. a specific database. You will notice that the list of alerts changes so that only those alerts which apply for this level are displayed. Now when you select the alert any changes that you make will only affect the configuration for this level e.g. you can disable the alert for this specific database.

Here is some more information on configuration options:
http://www.red-gate.com/supportcenter/Content?p=SQL%20Monitor&c=SQL_Monitor/help/3.0/SM_CustomizingAlerts.htm&toc=SQL_Monitor/help/3.0/toc1469820.htm
_________________
Chris Kelly
Technical Support Engineer
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group