Post reply

Alram tables

  • June 2, 2011 at 1:22 pm

    #237380

    Hi,everyone

    How to check the alerts using alram tables?

    New to field so please do help me

  • June 2, 2011 at 1:24 pm

    #1333329

    I'm not sure what you mean. I'm assuming "alram tables" is a typo for "alarm tables", but even that doesn't clarify the question for me.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • June 2, 2011 at 1:30 pm

    #1333337

    I think that the sysalerts table in msdb is updated with the last occurrence, but I don't think there's a history table of all alerts that have occurred.

  • June 2, 2011 at 1:30 pm

    #1333339

    I'm in the same boat as Gus, could you clarify Alarm Tables?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • June 2, 2011 at 1:40 pm

    #1333356

    I had a job that throws a error "check alarm tables for failed alerts"

    so i need to find that alert in the alarm tables?

    thanks for your quick response

  • June 2, 2011 at 1:42 pm

    #1333359

    That would be a custom error, most likely. Check for that.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • June 2, 2011 at 1:43 pm

    #1333360

    What's the job do? I'm not sure that's a SQL Server message.

  • June 2, 2011 at 1:50 pm

    #1333368

    Its a alram monitoring job

  • June 2, 2011 at 1:52 pm

    #1333371

    Do you have third party monitoring software that may have installed some tables by that name?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 9 posts - 1 through 8 (of 8 total)

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