Post reply

Need help - Automate SQL jobs and notification mail

  • September 27, 2019 at 11:12 am

    #3683948

    Hi All,

    I would like to monitor the  200(Approx)  SQL jobs  health checks every 5 mins and if any job failed in the last 15mins, it should trigger the alert.

    Please provide a your valuable suggestion on this? – is it possible to implement ? or any one already used this type of alert earlier?

    Thanks in advance!!

    SQL server DBA

  • September 27, 2019 at 11:39 am

    #3683956

    Hi,

    Are these jobs all on the server?

    All you need to do is;

    1. Set up DB Mail on the SQL Server - so SQL can send you a mail
    2. Create an operator on the SQL Server - so SQL knows who to mail.
    3. Then for each job set the on failure notification to email the operator created above in step 2.

    Alternatively what you could do is run a bit of SQL code to query msdb for job failures in the last 15 minutes.

    Personally I'd go with the DB mail option.

    Hope this helps.

    Thanks,

    Nic

    Check out my blog http://www.sqlservercentral.com/articles/Best+Practices/61537/

  • September 27, 2019 at 1:40 pm

    #3684023

    Thank you Nic, I will have to implement this using with appdynamics not a SQL side.

    Please provide a your valuable suggestions on this.

    SQL server DBA

  • September 27, 2019 at 6:38 pm

    #3684156

    Hi,

    I dont know anything about appdynamics sorry so I couldn't comment on the best way to do it.

    Why do you want appdynamics to do it? I'm curious.

    I'm not sure how much help people here will be, this is a SQL forum, whilst many of us have skills with other things I've never come across anyone mentioning appdynamics sorry.

    Thanks,

    Nic

    Check out my blog http://www.sqlservercentral.com/articles/Best+Practices/61537/

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

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