Post reply

Looking for sql agent job monitoring solution

  • August 31, 2015 at 10:38 am

    #307238

    Hi All,

    Need some guidance. Look for some job monitoring dashboard solution using tsql.

    For instance, if sql agent jobs are running more time than expected time then we need to get some email alerts with

    some job related information. kind of why it is stuck / still running.

    Did anybody worked on such time simple job monitoring solutions.

    If so, please guide me or provide some resources which can help me.

    Thanks in advance.

  • August 31, 2015 at 12:36 pm

    #1823454

    I've used this for a long time. It's simple and it works. I have since made many tweaks to fit my requirements such as stripping out the CLR.

    You can easily make your own changes to add what you want, remove what you don't.

    http://www.wisesoft.co.uk/articles/dba_daily_checks_email_report.aspx

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

  • September 2, 2015 at 12:35 am

    #1823871

    Thanks a ton for the help.

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

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