SQL JOB Alerts

Vijay used Ask the Experts™
How to create SQL JOB alerts for below once:

1. If CPU utilization reaches some x% threshod (need both Warning and Critical based on threshhold)
2. If SQL Services are stopped/restarted.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
IT Engineer
Distinguished Expert 2017
You can't do that with SQL Jobs as if the SQL Services are stopped if won't fire up those alerts.
You need to use some other external tool for that. Here is an example to set monitoring and alerts for high CPU usage.


Good information.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial