Post reply

Alerts & Operators

  • November 17, 2011 at 11:33 pm

    #246264

    Hi Guys

    When working with alerts, is there a specific alert that will notify a selected operator when the transaction log is full or at a certain percentage for the databases on the instance?

    Also, can the text be edited that sends out to the operators?

    Thanks

  • November 17, 2011 at 11:52 pm

    #1409693

    Should I suggest you some reading?

    Defining Alerts

    http://msdn.microsoft.com/en-us/library/ms180982.aspx

  • November 17, 2011 at 11:56 pm

    #1409694

    Dev (11/17/2011)

    Should I suggest you some reading?

    Defining Alerts

    http://msdn.microsoft.com/en-us/library/ms180982.aspx

    No Suggestion needed

    I found what I was looking for.

  • November 18, 2011 at 12:07 am

    #1409698

    derekr 43208 (11/17/2011)

    Dev (11/17/2011)

    Should I suggest you some reading?

    Defining Alerts

    http://msdn.microsoft.com/en-us/library/ms180982.aspx

    No Suggestion needed

    I found what I was looking for.

    can you share the solution which you found ?

  • November 18, 2011 at 12:28 am

    #1409703

    You can use following script for the alert. Provided that your Db mail should be configured and working properly.

    USE [msdb]

    GO

    EXEC msdb.dbo.sp_update_alert @name=N'Tempdb',

    @message_id=0,

    @severity=0,

    @enabled=0,

    @delay_between_responses=0,

    @include_event_description_in=1,

    @database_name=N'',

    @notification_message=N'Logspace is More than 60%.',

    @event_description_keyword=N'',

    @performance_condition=N'SQLServer:Databases|Percent Log Used|tempdb|>|80',

    @wmi_namespace=N'',

    @wmi_query=N'',

    @job_id=N'00000000-0000-0000-0000-000000000000'

    GO

    EXEC msdb.dbo.sp_update_notification @alert_name=N'Tempdb', @operator_name=N'Alert', @notification_method = 1

    GO

    Sagar Sonawane
    ** Every DBA has his day!!:cool:

  • November 18, 2011 at 2:31 am

    #1409739

    deepak.a (11/18/2011)

    derekr 43208 (11/17/2011)

    Dev (11/17/2011)

    Should I suggest you some reading?

    Defining Alerts

    http://msdn.microsoft.com/en-us/library/ms180982.aspx

    No Suggestion needed

    I found what I was looking for.

    can you share the solution which you found ?

    The alert is under object:SQLServer:Databases

    The counter is called: Percent Log Used

    I think this can only be done on 1 database at a time though

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply