June 19, 2016 at 7:38 am
I am using the SQL Agent job to send alerts when certain conditions are met and I have a few bugs that I need help with.
Bug One:
I created a job that checks the CPU usage of the server and will send the team an email if it is above 80%. The problem is that on one of the instances it does not return the CPU value in the email the others do. If I take the query and execute it in a query window the value for CPU usage shows up just fine. Do you have any idea what I can look for?
Bug two:
In two instances an email does not get delivered to me when using the agent job. I have tested the DB_Mail and it works fine. I again run the query in a query window and it also send me the email just fine and includes the CPU value, but for some reason the Agent Job will not fire off the email.
If you have any ideas your help would be appreciated.
Jeff
June 19, 2016 at 8:40 am
For both, you'll need to provide code. I'm not sure why #1 wouldn't return something without more detail.
For #2, are you sure this fires? I'd add logging code to your job, put a value in a table that would help you determine what is happening, or what variables are sent to DBMail and then review them if you think you didn't get an email.
June 19, 2016 at 6:51 pm
Thanks for the help.
I will try getting the code and give you more detail.
Jeff
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply