locked
SQL MP Job Last Run Status Monitor doesn't alert RRS feed

  • Question

  • Hi Guys,

    Last run Status Monitor in SQL MP that checks the last run status of agent jobs and generates alerts is not generating any alerts in SCOM. Although we had overrided the monitor to trigger the alerts.

    Jobs are discovered under SQL agent Job state view and state changes to warning as well but no alerts at all.

    Please guide.

    Regards,

    Daya Ram

    Thursday, February 12, 2015 1:56 PM

Answers

  • Hi!

    1. Enable "Generates Alert" by override.
    2. Set "Alert On State" to "The monitor is in a warning health state" by override.
    3. Optionally change the "Alert severity" so that it matches the health state.
    4. Set "Auto-Resolve Alert" to true by override.

    Cheers,
    Patrick


    Please remember to click “Mark as Answer” on the post that helped you.
    Patrick Seidl (System Center and Private Cloud)
    Website: http://www.syliance.com
    Blog: http://www.systemcenterrocks.com

    • Proposed as answer by Natalya Vank Friday, February 13, 2015 4:05 AM
    • Marked as answer by Yan Li_ Sunday, February 22, 2015 3:08 AM
    Thursday, February 12, 2015 4:51 PM
  • Hi,

    By default this monitor does not generate alerts, you should override it for all SQL agent Job.

    Regards,

    Yan Li


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.


    • Edited by Yan Li_ Friday, February 13, 2015 6:46 AM edit
    • Proposed as answer by Yan Li_ Wednesday, February 18, 2015 8:57 AM
    • Marked as answer by Yan Li_ Sunday, February 22, 2015 3:08 AM
    Friday, February 13, 2015 6:46 AM

All replies

  • Hi!

    1. Enable "Generates Alert" by override.
    2. Set "Alert On State" to "The monitor is in a warning health state" by override.
    3. Optionally change the "Alert severity" so that it matches the health state.
    4. Set "Auto-Resolve Alert" to true by override.

    Cheers,
    Patrick


    Please remember to click “Mark as Answer” on the post that helped you.
    Patrick Seidl (System Center and Private Cloud)
    Website: http://www.syliance.com
    Blog: http://www.systemcenterrocks.com

    • Proposed as answer by Natalya Vank Friday, February 13, 2015 4:05 AM
    • Marked as answer by Yan Li_ Sunday, February 22, 2015 3:08 AM
    Thursday, February 12, 2015 4:51 PM
  • Hi,

    By default this monitor does not generate alerts, you should override it for all SQL agent Job.

    Regards,

    Yan Li


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.


    • Edited by Yan Li_ Friday, February 13, 2015 6:46 AM edit
    • Proposed as answer by Yan Li_ Wednesday, February 18, 2015 8:57 AM
    • Marked as answer by Yan Li_ Sunday, February 22, 2015 3:08 AM
    Friday, February 13, 2015 6:46 AM
  • Hi,

    I have enabled "Generates Alert" but even when jobs fail I don't get any alerts generated.

    Any ideas as to why it doesn't work?


    /Per


    • Edited by Per J Wednesday, August 19, 2015 9:27 AM
    Wednesday, August 19, 2015 9:26 AM
  • Hi,

    Override the Alert on State to "monitor is in warning health state" then you should be able to get the alerts.

    Regards,

    Daya Ram

    Thursday, August 20, 2015 3:45 PM