Post reply

delay_between_responses in msdb.dbo.sysalerts

  • June 22, 2015 at 3:33 pm

    #319383

    Hello Experts,

    I have setups alerts to be thrown if there's any login failure. Now, was thinking to seek your feedback about "delay_between_ responses" value. If I set that to 0, it will throw the same alerts in every 1 sec.

    Instead if I change that to every 2 hrs, will the same alert be thrown in every 2 hrs or what happens?

    Did not get a good information in MSDN, as it only states : - "Wait period, in seconds, between notifications for this alert."

    Thanks much

    Thanks.

  • June 23, 2015 at 10:21 am

    #1807463

    Any update from anyone?

    Thanks.

  • June 23, 2015 at 1:32 pm

    #1807535

    what i would do:

    change the alert to call a stored procedure.

    Have that stored procedure insert details into a table.

    have a separate job run every two hours that emails you a recap of the failed logins over the last,two hours, and marks any existing records as "already processed", so they don't show up on the next email.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 3 posts - 1 through 3 (of 3 total)

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