October 27, 2007 at 10:09 am
Hello,
I have an odd problem. As part of a troubleshooting process, I disabled email notifications for the SQL Server Agent jobs on a server. I did this by going to Properties for each job, then the Notifications section, then unchecked the 'E-mail' checkbox under Actions to perform when the job completes.
But about 15 minutes after I did the steps above, I got another email from a job from which I am not supposed to be getting emails.
1. How can I check why these emails continue to go out?
2. How can I stop the emails?
Thanks for any help!
webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
October 27, 2007 at 10:16 am
Try disabling the Email Operator itself instead of disabling in each job.
Expand SQL server agent
Expand Oprator
Right click on the email operator and uncheck the enabled check box
click ok
Regards..Vidhya Sagar
SQL-Articles
October 27, 2007 at 11:20 am
vidhya sagar (10/27/2007)
Try disabling the Email Operator itself instead of disabling in each job.Expand SQL server agent
Expand Oprator
Right click on the email operator and uncheck the enabled check box
click ok
That looks like it did the trick. Thanks!
Now I can work on the other issues, such as why turning off individual notifications doesn't work. In that case, does one need to delete and recreate the job?
Thanks again,
webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
October 30, 2007 at 2:10 pm
That seems like a fairly weird problem, I'd try stopping the SQL Server Agent and starting it again.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply