Kaseya Community

Home » Discussion Forums » Monitoring - VSA » SQL Maintenance Plan Monitoring

Learn more about how AuthAnvil can protect and enhance your Kaseya experience

Similar Posts

Planned Maintenance on Community

by
on May 18, 2016

Plans for Exchange & SQL patching

by
on Jun 1, 2006

SQL Database Maintenance Tasks

by
on Sep 29, 2010
  • Suggested Answer

Monitor backup plan when Kaseya service is stopped

by
on Jul 29, 2011

SQL Monitoring

by
on Nov 16, 2009
Details
  • 4 Replies
  • 4 Subscribers
  • Postedover 8 years ago

SQL Maintenance Plan Monitoring

This question is answered
kcroft
Posted by
on Sep 2, 2011 3:30 AM

Hi

I was just wondering if anyone has some advise on using Kaseya to monitor a custom maintenance plan in MS SQL. We've set up a plan to rebuild an index of a particular DB once a week and would like a notification of completion (success or fail). Any advise/tips/best practice would be appreciated.

Cheers

Kevin
Verified Answer
  • StevenCH
    Posted by
    on Sep 2, 2011 3:49 AM
    Verified Answer
    Verified by

    Hi Kevin,

     

    You could set up an Event Set to monitor for the appropriate event IDs for success & fail. Then configure it to send an email or alert when they occur.

     

    Steven

     

    From: kcroft [mailto:bounce-kcroft@kaseya.com]
    Sent: Friday, 2 September 2011 12:49 PM
    To: community_monitoring@kaseya.com
    Subject: [Kaseya Community: Monitoring] SQL Maintenance Plan Monitoring

     

    Hi

    I was just wondering if anyone has some advise on using Kaseya to monitor a custom maintenance plan in MS SQL. We've set up a plan to rebuild an index of a particular DB once a week and would like a notification of completion (success or fail). Any advise/tips/best practice would be appreciated.

    Cheers

    Kevin
All Replies
  • StevenCH
    Posted by
    on Sep 2, 2011 3:49 AM
    Verified Answer
    Verified by

    Hi Kevin,

     

    You could set up an Event Set to monitor for the appropriate event IDs for success & fail. Then configure it to send an email or alert when they occur.

     

    Steven

     

    From: kcroft [mailto:bounce-kcroft@kaseya.com]
    Sent: Friday, 2 September 2011 12:49 PM
    To: community_monitoring@kaseya.com
    Subject: [Kaseya Community: Monitoring] SQL Maintenance Plan Monitoring

     

    Hi

    I was just wondering if anyone has some advise on using Kaseya to monitor a custom maintenance plan in MS SQL. We've set up a plan to rebuild an index of a particular DB once a week and would like a notification of completion (success or fail). Any advise/tips/best practice would be appreciated.

    Cheers

    Kevin
  • Hans den Boer
    Posted by
    on Sep 2, 2011 3:25 PM

    we have SQL send an email when the maintenance plan fails to a local administrator, and monitor the event log for failures
  • kcroft
    Posted by
    on Sep 5, 2011 3:00 AM

    Thanks guys for the tips. We can't setup SQL to mail us because of unique factors in the environment but montoring the particular event should do the trick. Thanks for the replies
  • Alistair Curran
    Posted by
    on Sep 5, 2011 10:11 AM

    The Event ID you're looking for is 208 which appears to cover most errors.  We've certainly get a huge pile of them through.