SQL JOB Alerts

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.
Who is Participating?
Vitor MontalvãoMSSQL Senior EngineerCommented:
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.
VijayAuthor Commented:
Good information.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.