SQL JOB Alerts

Vijay
Vijay used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
IT Engineer
Distinguished Expert 2017
Commented:
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.

Author

Commented:
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